Normalization separates different kinds of facts that were mixed into one table. If every order copies a customer address, changing that address means updating every order.
The demo turns repeated customer names into one customer row and references from orders. Too much splitting can require more joins, so weigh integrity against real query patterns.
When to use
Consider it when repeated values cause update or delete anomalies.