Airline Flight Operations Schema

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

senior

Interview Prompt

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.

How This Interview Works

1. Read the vague prompt (just like a real interview)
2. Ask clarifying questions to the AI interviewer
3. Write your data modeling solution with real code execution
4. Get instant feedback and a hire/no-hire decision