These notes are from the 2006 offering of the course. They 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 CS352 may reproduce these notes for
personal study; all other rights are reserved.
- Course Introduction; Fundamental DBMS Concepts
- Data Models
- The Relational Database Model
- Examples of Relational Queries in Relational Algebra and SQL
- SQL
- Relational Calculus; QBE
- Integrity and Security Contraints
- Database Design: The Entity-Relationship Model
- Database Design and Normalization
- Database Application Development
- Object-Based Databases
- XML
- File Structures and System Organization
- Indexes
- Query Processing / Optimization
- The Transaction Concept
- Concurrency
- Crash Recovery
- Decision Support Systems, Data Mining
- Database System Architectures
- Distributed Databases