A flat orders table stores customer_name and customer_email alongside each order

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

A flat orders table stores customer_name and customer_email alongside each order. When a customer changes their email, every order row must be updated. Split this into two normalized tables: customers and orders.

Practice This Problem

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