The Long Route

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

Domain

Data Modeling

Difficulty

hard

Seniority

L5

Problem

We run a large e-commerce marketplace. A unit is bought from a vendor, received at one of our fulfillment centers, then picked, packed, and shipped to the customer. A single order often splits across several fulfillment centers, and one outbound truck can carry items from many different orders. Operations needs to see not just where every unit sits right now, but the full path it took to get there. Design the data model.

Summary

A package splits, reroutes, and (maybe) arrives.

Practice This Problem

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