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
...