Solution to Exercise 2
Explore the process of bringing a database table to third normal form by eliminating transitive dependencies. This lesson helps you understand how to separate related data into different tables, use foreign keys effectively, and improve database efficiency through proper normalization.
We'll cover the following...
We'll cover the following...
Solution
A table is in third normal form when the following conditions are met:
-
It is in the second normal form.
-
All non-primary fields are dependent on the primary key.
Customer table
| Cust_Id | Cust_Name | DOB | Area | City | State | Zip |
|---|---|---|---|---|---|---|
| 1 | Jack | 1996-01-13 | 777 Brockton Avenue | Abington | MA | 2351 |
| 2 | Bruce | 1995-09-22 | 3018 East Ave | Central Square |