DATABASE MANAGEMENT SYSTEMS - syllabus

ANNA UNIVERSITY TRICHY SYLLABUS

CA5105 DATABASE MANAGEMENT SYSTEMS-syllabus

LTPC

3003 UNIT I FUNDAMENTALS 9

Database Systems vs. File Systems – View of Data – Data Models – Database Languages – Transaction Management – Database Systems Structure – History of Database Systems – Database Systems Applications – Entity Relationship Model.

UNIT II RELATIONAL DATABASES 9

The Relation – Keys – Constraints – Relational Algebra and Calculus – Queries – SQL – Basic Structure – Set Operations – Complex Queries – Joined Queries – DDL – Embedded SQL – Dynamic SQL – Other SQL Functions – Query by Example – Integrity and Security of searching – Relational Database Design.

UNIT III DATA STORAGE AND INDEXING 9

Storage & File Structure – Disks – RAID – File Organization – Indexing & Hashing – B+ Tree – B Tree – Static Hashing – Dynamic Hashing – Multiple Key Access.

UNIT IV QUERY EVALUATION & OPTIMIZATION 9

Query Processing – Selection Operation – Sorting – Join Operation – Evaluation of Expressions – Query Optimization.

UNIT V TRANSACTION MANAGEMENT 9

Transaction Concept – Static Implementation – Concurrency Control – Protocols – Deadlock Handling – Recovery Systems – Recovery with Concurrent Transactions – Shadow Paging – Buffer Management – Case Studies – Oracle – Microsoft SQL Server.

Total: 45

TEXT BOOKS

1. Abraham Silberschatz, Henry F. Korth and S. Sudharsan, “Database System Concepts”, Fifth Edition, Tata McGraw Hill, 2006.

2. C.J Date, A. Kannan and S. Swamynathan, “An Introduction to Database Systems”, Eighth Edition, Pearson Education, 2006.

REFERENCES

1. Raghu Ramakrishnan and Johannesgerhrke, “DataBase Management Systems”, Third Edition, McGraw Hill, 2003.

2. R. Elmasri, S.B. Navathe, “Fundamentals of Database Systems”, Pearson Education, 2004.