MA40004: File Organisation And Data Base Systems
Jump to navigation
Jump to search
| MA40004 | |||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Course name | File Organisation And Data Base Systems | ||||||||||||||||||||||||||||
| Offered by | Mathematics | ||||||||||||||||||||||||||||
| Credits | 4 | ||||||||||||||||||||||||||||
| L-T-P | 3-1-0 | ||||||||||||||||||||||||||||
| Previous Year Grade Distribution | |||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||
| Semester | Spring | ||||||||||||||||||||||||||||
Syllabus
Syllabus mentioned in ERP
Prerequisite: Programming LanguagesDatabase concepts, entity relationship model, relational network and hierarchical data models. Relational database design, functional and multi-valued dependency. Normal form, data description languages, relational algebra and calculus, SQL, query facility and query optimization. Introduction to distributed databases implementation issues. Storage media and storage structure, file and index organization. Heap file, indexed file, B tree file, denie index, file with variable length records, performance and evaluation.