Design a product dimension table with surrogate keys

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 product dimension table with surrogate keys. Include the surrogate key (product_key), the natural business key (product_id), and descriptive attributes. The surrogate key is database-generated and never changes.

Practice This Problem

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