10: Database Design

Covering database design with multiple tables, foreign keys, and the JOIN operation..

Slides

• SQL-02-MySQL-Design.ppt

Videos

• Data Modeling - Building a Data Model (Part 1)
• Data Modeling - Representing Relationships (Part 2)
• Data Modeling - Relationships in SQL (Part 3)
• Data Modeling - Using Join (Part 4)
• Data Modeling - Many-To-Many (Part 5)

References

• Multi-Table SQL Handout
• Book: Chapter 38 - Data relationships
• Book: Chapter 40 - Normalization
• Book: Chapter 42 - Advanced Queries

Assignment

• Assignment Specification

Discussions

• Database Design (Login Required)
  

Tools

• Quiz: Database Models (Login Required)
  
• Peer Grader: Multi-Table Databases (Tracks) (Login Required)
  
• Autograder: Many-to-Many Databases (Login Required)