BookMyCollege
Indian Institute of Technology Delhi
B.Tech Computer Science
Database Management Systems
Year 2 Semester 4 Academic Year: 2024-25

Unit 1: Relational Model — ER Diagrams, Relational Algebra

Unit 2: SQL — DDL, DML, Joins, Subqueries, Triggers, Stored Procedures

Unit 3: Normalization — 1NF, 2NF, 3NF, BCNF

Unit 4: Transaction Management — ACID Properties, Concurrency Control

Unit 5: Indexing & Query Optimization — B+ Trees, Hashing