Slide 23
Slide 23 text
Intro to Databases
What about relationships?
23
Let’s think about people and cars.
We’ll have two tables. people and cars
● If a person can have a single car, add a column in
the people table for a car ID
● If a car can have a single person, add a column in
the cars table for a person ID
● Otherwise, use a separate table storing
(car, person) rows.