Database Design

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

• 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)

• Slides

  • SQL-02-MySQL-Design.ppt
• Assignment Specification

• References

  • Multi-Table SQL Handout
  • Book: Chapter 38 - Data relationships
  • Book: Chapter 40 - Normalization
  • Book: Chapter 42 - Advanced Queries
• 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)