Das Szenario
A tricycle association needs a database to track drivers, their tricycles, and reportable accidents and incidents.
Was diese Zeichnung zeigt
Die dahinterstehenden Entscheidungen verstehen.
01
Separate tables for accidents and incidents to allow distinct attributes
02
Driver-to-Tricycle as one-to-many assuming a driver may operate multiple tricycles
03
Mandatory relationships to enforce data integrity
Use this schema for any vehicle association or fleet management system requiring incident tracking.