The scenario
A DMV-style system needs to track owners, vehicles (motorcycles and off-highway), their manufacturers and classes, plus registration records with issue and expiry dates.
What is in this drawing
Read the decisions behind it.
01
Separate VehicleClass table to distinguish motorcycle vs off-highway and support future vehicle types
02
Registration table as association entity between Owner and Vehicle to record ownership and registration periods
03
Foreign keys from Vehicle to Manufacturer and VehicleClass for referential integrity and lookup
Reuse for any state or regional vehicle registration database that must capture owner-vehicle relationships, vehicle classification, and registration lifecycle.
More like this