Lo 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.
Cosa contiene questo disegno
Leggi le decisioni che ne stanno alla base.
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.