A easy Data Modeling interview practice problem on DataDriven. Write and execute real data modeling code with instant grading.

Domain

Data Modeling

Difficulty

easy

Seniority

L3

Problem

A seller on our marketplace wants to see their total products listed and total revenue earned per day. Design the data model that supports this view, and choose between a dimensional model or an ER model. Justify your choice. Then write the SQL to produce the report.

Summary

They want a total. Give them the right schema first.

Practice This Problem

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