The scenario
Designing a database for a smart bus ticketing platform that provides real-time tracking of buses and automatic fare calculation based on trip segments.
What is in this drawing
Read the decisions behind it.
01
Modeled stops and routes as separate entities with sequencing
02
Integrated real-time trip tracking with actual departure and arrival timestamps
03
Linked tickets to passengers and trips for fare calculation
When building a bus-based public transportation system with electronic ticketing and GPS tracking.
More like this