Database Management Systems(MA607)
Course Name:
Database Management Systems
Programme:
MCA
Semester:
Second
Category:
Programme Core (PC)
Credits (L-T-P):
(3-0-0) 3
Content:
Files versus database systems, Three-level architecture of databases, Data Models, ER-diagram, EER-model, Relational model, ER-Relational mapping, Relational algebra and calculus. Query languages, SQL, Embedded SQL, Relational database design algorithms, Normalization, Physical database organization, Indexing and hashing, Transaction processing, Concurrency control techniques, Database recovery techniques, Database security and authorization.
References:
Ramez Elmasri, Shamkant B Navathe, Fundamentals of database system, Addison Wesley, McGraw-Hill, 2000.
Silberschatz Korth and Sudarshan, Database System Concepts, McGraw Hill.
Ramakrishnan, R., Gehrke, Database Management Systems, Third edition McGraw Hill.
Department:
Mathematical and Computational Sciences
