CA768

DATABASE MANAGEMENT SYSTEMS

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", 3^rd Edition, 1997, Mc-Graw Hill

2. Date C.J,-"An Introduction to Database Systems", Sixth Edition, Addison Wesley.

© WebTeam NIT Trichy,
National Institute of Technology, Tiruchirappalli