A ride-sharing company needs a data model to support both operational systems and analytics. Walk through how you would design this model, covering the key entities, relationships, and trade-offs.

Sample answer preview

Designing a data model for a ride-sharing company requires supporting both real-time operational needs and historical analytics. These two concerns often lead to different modeling decisions, so I would design separate but connected models.