The Meter's Running

A medium Data Modeling interview practice problem on DataDriven. Write and execute real data modeling code with instant feedback.

Domain

Data Modeling

Difficulty

medium

Seniority

L5

Problem

We run a ride-sharing marketplace and need a data model that follows every ride through its full lifecycle, from the moment a rider requests one to the drop-off, capturing where each trip started and ended, how far it went, the fare, and the surge multiplier in effect. Analysts measure driver utilization as the share of a driver's online time spent carrying a passenger, so we also record every time a driver goes online or offline, and they track weekly rider retention and revenue. Design the schema behind these dashboards.

Summary

Riders, drivers, and fares. Everyone takes a cut.

Practice This Problem

Solve this Data Modeling problem with real code execution. DataDriven runs your solution and checks it automatically.