Slightly More Complex Data Model

Problem: 

In our movie database, how can store items like cast , director, or genre with out duplicating data  that is scalable and easy to use.

Solution:

Foreign Keys

Foreign Keys

A column on a table (Table A) that references the Primary key of another table (Table B) 

To the whiteboard!

Lets all go to movies