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.