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're an airline and we want to build a data warehouse to analyze flight operations. We need to understand on-time performance, load factor, and revenue per seat mile. Finance, operations, and product all consume this data. Design the data model.

Summary

Flights, passengers, and routes. Before you draw a single table, tell me the grain.

Practice This Problem

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