Design a system to manage redundant denormalized data

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 system to manage redundant denormalized data. Create a products table with a cached category_name and a separate categories table as the source of truth, plus a sync_log to track when caches were refreshed.

Practice This Problem

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