The Last Mile
A medium Data Modeling mock interview question on DataDriven, with an AI interviewer who asks follow-up questions and a hire or no-hire decision at the end.
- Domain
- Data Modeling
- Difficulty
- medium
- Seniority
- L4
Interview Prompt
An order on our platform can ship in multiple packages, each moving separately through the carrier network from warehouse to doorstep. Operations needs to see every order's current status alongside the scan-by-scan history of each package. Design the data model.
Summary
Order placed. Now track it to the door.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Draw your data model on the schema canvas: tables, keys and relationships
- Answer the interviewer's follow-up questions, then get a hire or no-hire decision