Data Engineering, Interview, Data Modeling.
(airport, mall, etc.), latitude, longitude, and related_location_id to link locations that are related but distinct. Lastly, the Trip entity would have fields such as trip_id, rider_id, driver_id, start_location_id, end_location_id, start_time, end_time, trip_status (like “ongoing”, “completed”),