An e-commerce product page needs to show product name, category, and average rating

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

An e-commerce product page needs to show product name, category, and average rating. Instead of computing the average on each request, design a denormalized products table that stores the pre-computed average alongside the normalized data.

Practice This Problem

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