السيناريو
A tricycle association needs to manage drivers, their registered tricycles, defined routes, and schedule daily assignments of drivers to tricycles on specific routes.
ما الذي يتضمنه هذا الرسم
اقرأ القرارات الكامنة وراءه.
01
Each driver and tricycle must be associated with one association.
02
Assignments link drivers, tricycles, and routes for a given date and shift.
03
Associations can exist without drivers or tricycles initially.
When designing a database for small-scale public transport management with fixed routes and driver-vehicle assignments.