Das Szenario
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.
Was diese Zeichnung zeigt
Die dahinterstehenden Entscheidungen verstehen.
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.