Chapter 6
- Domain constraints
- Referential Integrity
- Assertions and Triggers
- Security and Authorization (in SQL)
Chapter 7
- Pitfalls in relational DB design
- Functional dependencies
- Decomposition and desirable properties
of decomposition
- Normal forms (1NF, BCNF, 3NF)
Chapter 12
- Basic concepts and Ordered indices
- B+ Tree and B-Tree
- Static and dynamic hashing
Chapter 15
- Transaction Concept
- Transaction state
- Atomicity and Durability
- Concurrent executions
- Serializability and testing for
serializability
Chapter 16
- Lock-based protocols
- Timestamp-based protocols