There are five tables in the Cars database:

• the person table (entity)
• the manufacturer table (entity)
• the model table (entity)
• the car table (entity)
• the ownership table (relation)

They are diagrammed below.

ownership

id	owner	car
1	1	1
2	2	1
3	3	2

person

id	name
1	Doe, Janet
2	Doe, John
3	Smith, Jim

car

id	vin	model
1	0123456789abcdefg	1
2	abcdefg0123456789	3

model

id	name	manufacturer
1	Camry	3
2	Fusion	1
3	Buick Regal	2

manufacturer

id	name
1	Ford
2	General Motors
3	Toyota

ownership-view

Owner	Make	Model	VIN
Doe, Janet	Toyota	Camry	0123456789abcdefg
Doe, John	Toyota	Camry	0123456789abcdefg
Smith, Jim	General Motors	Buick Regal	abcdefg0123456789