상황
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.