The Double Count
A medium Data Modeling mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- Data Modeling
- Difficulty
- medium
- Seniority
- L5
Interview Prompt
We run an airline and we're standing up a warehouse so finance, operations, and product can all work from the same numbers: how late each flight pushed back and what caused the delay, how full each flight flies, and the revenue earned per seat mile. The catch is that one flight carries hundreds of passengers while a single passenger's itinerary stretches across several connecting flights, so any model that mixes the two ends up double counting either seats or fares. Keep what happens to a flight separate from what happens to each passenger's journey, and store the raw operational numbers so they still roll up correctly across routes and days.
Summary
One flight carries hundreds of seats; one ticket spans many flights. Model them so neither gets counted twice.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write your data modeling solution with real code execution
- Get instant feedback and a hire/no-hire decision