Data Relationships

Multi-Table SQL and Relationships.

• Videos

  • Relational Database Design Part 1
  • Relational Database Design Part 2
  • Database Keys
  • Database Normalization
  • Building Tables
  • Inserting Data
  • Using JOIN Across Tables
  • Many-to-Many Relationships
  • Demonstration: Database Design and Many to Many

• Slides

  • 02-Database-Design-Many-to-Many.ppt

• References

  • Sample SQL For Lecture
  • High Contrast / Printable Slides
• Discussions:
  • Data Relationships (Login Required)
    
• Tools:
  • Quiz: Data Relationships (Login Required)
    
  • Autograder: Entering Many-to-One Data - Automobiles (Login Required)
    
  • Autograder: Building a many-to-many roster (Login Required)