MC9213 DATABASE MANAGEMENT SYSTEMS Syllabus for 1st Sem MCA - First semester - Regulation 2009 - Anna University


MC9213 DATABASE MANAGEMENT SYSTEMS Syllabus for 1st Sem MCA - First semester - Regulation 2009 - Anna University

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 PERIODS 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.
Previous
Next Post »