Lecture Notes for CPS352: Database Systems

These notes are placed here primarily to assist students enrolled in the course; they are not intended as polished documents. All notes are copyright © Russell C. Bjork. Students enrolled in CPS352 may reproduce these notes for personal study; all other rights are reserved.

  1. Course Introduction; Fundamental DBMS Concepts
  2. Data Models
  3. The Relational Database Model
  4. Database Design: The Entity-Relationship Model
  5. SQL
  6. Relational Calculus;QBE
  7. Database Design and Normalization
  8. Database Application Development
  9. File Structures and System Organization
  10. Indexes
  11. Query Processing / Optimization
  12. The Transaction Concept
  13. Concurrency
  14. Crash Recovery
  15. Database System Architectures
  16. Distributed Databases
  17. Other DBMS Models
  18. Decision Support Systems, Data Mining