Introduction
  • Introduction
Introduction to Database Concepts
  • Entities and Attributes
  • Relations
  • Data Integrity
  • Atomicity
  • Primary and Foreign Keys
  • What is a Relationship?
Let's Conceptualize!
  • Conceptual Vs. Physical Relationships
  • One-to-One Relationships (Conceptual)
  • One-to-Many Relationships (Conceptual)
  • Many-to Many-Relationships (Conceptual)
  • Sometimes You Decide on the Relationship
Foreign keys in More Detail
  • Referential Integrity
  • Parent and Child Tables
  • NOT NULL
The Relationships!
  • How to Structure One-to-One Relationships
  • One-to-One Examples
  • How to Structure One-to-Many Relationships
  • One-To-Many Examples
  • How to Structure Many-to-Many Relationships
  • Many-to-Many Examples
  • Think you can structure relationships?
Conclusion
  • Conclusion