Design a date dimension table with rich attributes for slicing and dicing

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 date dimension table with rich attributes for slicing and dicing. Include fields like full_date, day_of_week, month_name, quarter, year, is_weekend, and is_holiday to support flexible reporting.

Practice This Problem

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