Database Management
Chapters
1. ER Model and Relational Model
Entity-Relationship, relational schema, keys.
2. SQL
DDL, DML, joins, subqueries, aggregations.
3. Normalization
1NF, 2NF, 3NF, BCNF, functional dependencies.
4. Transactions and Concurrency
ACID, serializability, 2PL, deadlock, recovery.
5. Indexing and B+ Trees
Primary, secondary, clustered indexes; B+ tree structure.