What is a Data Model?; The Relational Model; SQL is not Relational  

  1. The Janus Term
  2. Data Models Provide ...
  3. Structure
  4. Integrity
  5. Manipulation
  6. The Relational Model
  7. The Relational Model: Structure
  8. The Relational Model: Structure Example
  9. Relations are Predicates
  10. The Relational Model: Integrity - Attribute and Type
  11. The Relational Model: Integrity - Relation
  12. The Relational Model: Integrity - Database
  13. The Relational Model: Manipulation
  14. The Relational Model: Manipulation
  15. The Relational Model: Manipulation - Relational Algebra
  16. Why SQL is not relational: Bags, not Sets
  17. Why SQL is not relational: Ordering, Namelessness, and Name Duplication
  18. Why SQL is not relational: Poor Data Type Support
  19. Why SQL is not relational: Poor Integrity Support
  20. Why SQL is not relational: Physical/Logical Confusion
  21. Summary
  22. More resources
Copyright © 2005-2006 David Rolsky