OBJECTIVE:
To learn different database models and design of databases and to study query languages and transaction management.
File System versus DBMS – Advantages – Database Languages – ER-Model: Entities – Relationships – Additional Features of ER Model – Conceptual Design with ER Model
Relational Model – Keys - Constraints – Querying – Views - Relational Algebra – Relational Calculus – SQL – QBE
File Organization – Organization of records in files – Indexing – Ordered Indices - B + Tree Index files – Hashing – Static – Dynamic – Query Optimization – Transformation of Relational Expressions – Choice of evaluation plans
Database Design – Pitfalls in Relational Database Design – Functional Dependencies – Decomposition – Normalization – I to V Normal Forms
DB Tuning – Security – Transaction Management – Transactions – Transaction state – Concurrent executions – Serializability – Concurrency Control – Protocols – Crash Recovery
REFERENCES:
1. Raghu Ramakrishnan and Johannes Gehrke, “Data Base Management Systems”, 3rd Edition, McGraw-Hill, 2003.
2. Silberschatz, Korth and Sudarshan, “Data Base System Concepts”, McGraw-Hill, 6th Edition, 2010.
3. C. J. Date, “An Introduction to Database Systems”, 8th Edition, Addison-Wesley, 2003.
4. R. Elmasri, S.B. Navathe, “Fundamentals of Database Systems”, 5thEdition, Pearson Education/Addison Wesley, 2007.
COURSE OUTCOME:
Students will be able to:
1. Illustrate the features of DBMS & Models for designing databases
2. Describe the nuances of Data retrieval methods
3. Apply normalization techniques in DB design
4. Perform concurrency and Transaction Management operations
