The graphic below shows the Customer Table being split into the three tables
1) Customer, 2) Item, and 3) Order tables.
Customer Table is split into Customer, Item, and Order tables
Now when you enter an order for an item, you are storing only the item ID, customer ID, and quantity ordered in the order information table.
The other information, the specifics that are referenced by their ID, is stored separately. This leads to one other very significant benefit. If you change the customer's address, the new address is reflected systemwide. Any record that references it will have the correct address, without the need to update each individual reference.
Table Normalization - Exercise
Click the Exercise link below to practice on a different table. Table Normalization - Exercise
In the next several lessons, we will look at different forms of normalization.