Topics
Chapter 6 : Integrity constraints (keys, closure, cover etc.) Like the homework.
Chapter 7: Relational database design (various normal forms)
Chapter 11: Indexing and Hashing (B+ tree, hashing)
Chapter 12 : Query Processing (Query plans, and evaluation)
Chapter 13: Transactions (Concurrency and serializability)