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. The Relational Database Model; Relational Algebra
  3. Database Design: The Entity-Relationship Model
  4. SQL
  5. Relational Calculus;QBE
  6. Database Design and Normalization
  7. Database Application Development
  8. File Structures and System Organization
  9. Indexes
  10. Query Processing / Optimization
  11. The Transaction Concept
  12. Concurrency
  13. Crash Recovery
  14. Database System Architectures
  15. Distributed Databases
  16. Support for OO
  17. NoSQL Databases
  18. Decision Support Systems, Data Mining