Solution to Exercise 2
In this lesson we will discuss the solution to exercise 2.
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 |