CS 499 Lecture Outline

  1. Databases and Database Users

  2. Database System Concepts and Architecture

  3. Data Modeling Using the Entity-Relationship Model

  4. Storage Devices, Blocks, Buffers, and File Organizations

  5. Index Structures for Files

  6. The Relational Data Model and Relational Algebra

  7. Relational Algebra

  8. SQL - A Relational Database Language

  9. SQL Commands (Chapter 7)

  10. Design Guidelines and Functional Dependencies (Chapter 12)

  11. Normalization (Chapter 12)

  12. Query Optimization (Chapter 16)

  13. Transaction Processing Concepts (Chapters 17 & 18)

Last update November 17, 1997.