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.
Showing posts with label Database Management System. Show all posts
Showing posts with label Database Management System. Show all posts
Monday, June 21, 2010
Subscribe to:
Comments (Atom)