The Handoff

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

Domain

Data Modeling

Difficulty

hard

Seniority

mid

Problem

DoorDash's logistics team is reviewing delivery speed by merchant and market, and a single delivery can be handed from one Dasher to another before the food arrives. They also need each Dasher's total pay, including tips that customers adjust in the hours after delivery. Design a model that supports on-time analysis per merchant and accurate Dasher pay even as assignments and tips change after the order completes.

Practice This Problem

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