الطلب
“A bus ticketing database with Passenger, Bus, Route, Stop, RouteStop, Schedule, Ticket, and Payment tables. Schedules link routes and buses; tickets link passengers and schedules; payments belong to tickets.”
جرّب إذنAdd a driver assignment to each scheduleAdd a fare zone for each stop
ما الذي يتضمنه هذا الرسم
اقرأ القرارات الكامنة وراءه.
01
Included composite primary key for route-stop mapping
02
Separated Payment entity for normalization
03
Added stop ordering in RouteStop junction table
When modeling the database schema for a bus ticketing platform that needs to track stops, schedules, bookings, and payments.