Design a fact table at the order-line-item grain

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

Domain

Data Modeling

Difficulty

medium

Problem

Design a fact table at the order-line-item grain. Each row represents one product in one order. Include the foreign keys to dimension tables and the measurable facts (quantity, unit_price, line_total).

Practice This Problem

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