The scenario
A tricycle association needs a database to track drivers, their tricycles, and reportable accidents and incidents.
What is in this drawing
Read the decisions behind it.
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.
More like this