DATABASE MANAGEMENT SYSTEMS

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.