Database Management Systems(MCA701)

Course Name: 

Database Management Systems

Programme: 

MCA

Semester: 

Second

Category: 

Programme Core (PC)

Credits (L-T-P): 

(4-0-0) 4

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
 

Contact us

B R Shankar, Associate Professor and Head
Department of MACS, NITK, Surathkal
P. O. Srinivasnagar, Mangalore - 575 025
Karnataka, India.

  • Hot line: +91-0824-2474048

Connect with us

We're on Social Networks. Follow us & get in touch.