Final exam review topics:

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