Database Management System - Syllabus

MC9213 DATABASE MANAGEMENT SYSTEMS
L T P C
3 0 0 3
UNIT I INTRODUCTION 9
Historical perspective - Files versus database systems - Architecture - E-R model - Security and Integrity - Data models.

UNIT II RELATIONAL MODEL 9
The relation - Keys - Constraints - Relational algebra and Calculus - Queries - Programming and triggers

UNIT III DATA STORAGE 9
Disks and Files - file organizations - Indexing - Tree structured indexing - Hash Based indexing

UNIT IV QUERY EVALUATION AND DATABASE DESIGN 9
External sorting - Query evaluation - Query optimization - Schema refinement and normalization - Physical database design and tuning - Security

UNIT V TRANSACTION MANAGEMENT 9
Transaction concepts - Concurrency control - Crash recovery - Decision support - Case studies

TOTAL = 45
REFERENCES:

1. Raghu RamaKrishnan and Johannes Gehrke, “Database Management Systems”, McGraw Hill International Editions, 2000.
2. C. J. Date, “An Introduction to Database Systems”, Seventh Edition, Addison Wesley, 1997.
3. Abraham Silberschatz, Henry. F. Korth and S. Sudharshan, “Database system Concepts”, Third Edition, Tata McGraw Hill, 1997.