| Module | Important Topics |
|---|
| Module 1: Introduction to Database Systems | Database System Concepts, Database System Architectures, Data Models, Schemas, and Instances, Three-schema architecture and Data Independence, Database Language and Interfaces, Database System Environment |
| Module 2: Data Modeling Using the Entity-Relationship Model | ER model concepts, notation for ER diagram, mapping constraints, keys, Concepts of Super Key, Candidate Key, Primary Key, Generalization, Aggregation, Reduction of an ER schema to tables |
| Module 3: Relational Model, Constraints, and SQL | Relational Model Concepts, Integrity Constraints: Domain, Referential Integrity, Assertions, Triggers, SQL: DDL, DML, DCL commands, Views, and Indexes |
| Module 4: Database Design and Normalization | Functional dependencies, Normal forms: 1NF, 2NF, 3NF, BCNF, 4NF and 5NF, Decomposition using functional dependencies, Lossless join and dependency preserving decomposition, Database Design Process |
| Module 5: Transaction Management and Concurrency Control | Transaction concepts, ACID properties, Transaction and System Concepts, Schedule and Recoverability, Concurrency Control: Locking Techniques, Timestamp ordering, Multiversion and Optimistic Concurrency Control Techniques, Deadlock handling |
| Module 6: Database Security | Database security issues, Discretionary Access Control and Mandatory Access Control, Encryption and Public Key Infrastructures, Database Auditing |
