A customer table just overwrites old addresses with new ones

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 customer table just overwrites old addresses with new ones. There is no way to see what address a customer had when they placed an old order. Design a customer table that could support historical tracking.

Practice This Problem

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