The Double Count

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

Domain

Data Modeling

Difficulty

medium

Seniority

L5

Problem

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.

Practice This Problem

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