シナリオ
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.
この図に含まれるもの
図の背後にある意思決定を読み解く。
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.