Learn SQL Lesson

One Row to Update in a Good Schema

Now compare that with a normalized design. Customer facts live in the `customers` table, while `orders` only stores `customer_id`.

If Alice moves, you update her row once in `customers`. Her orders do not need their own copies of city and email.

This is one of the main reasons normalized tables are easier to maintain correctly.

Practice challenge

Return the single customer row you would update for Alice Kim. Show customer_id, customer_name, and customer_city.

Open interactive editor