Design a star schema for retail sales

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 star schema for retail sales. Create a central fact_sales table surrounded by dim_date, dim_product, and dim_store dimension tables. The fact table should reference all dimensions via foreign keys.

Practice This Problem

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