Pre-requisites: CA 767, CA 770
Co-requisite: CA 766
Outline:
Introduction to database systems -Database Administration - Database system architecture and data dictionary- Relational, Hierarchical, Network Models.
E-R models - Relational algebra - relational calculus and SQL.
Relational Database Design - Functional dependencies - Normal Forms.
Concurrency control- backup and recovery- integrity and security- Database performance- tuning and monitoring. Concepts on distributed database systems.
Current DBMS packages – SQL.
Books:
1. Korth, Silbershatz and Sudarshan- "Database System Concepts", 3rd Edition, 1997, Mc-Graw Hill
2. Date C.J,-"An Introduction to Database Systems", Sixth Edition, Addison Wesley.
