UNIT I
INTRODUCTION
Historical perspective - Files versus database systems - Architecture - E-R model - Security and Integrity - Data models.
UNIT II
RELATIONAL MODEL
The relation - Keys - Constraints - Relational algebra and Calculus - Queries - Programming and triggers
UNIT III
DATA STORAGE
Disks and Files - file organizations - Indexing - Tree structured indexing - Hash Based indexing
UNIT IV
QUERY EVALUATION AND DATABASE DESIGN
External sorting - Query evaluation - Query optimization - Schema refinement and normalization - Physical database design and tuning - Security
UNIT V
TRANSACTION MANAGEMENT
Transaction concepts - Concurrency control - Crash recovery - Decision support - Case studies
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.
