19
5
Concepts of Database Management, 4th Edition, Pratt & Adamski
Procedure:
Step 1: For each determinant that is not a candidate key, remove from the table the columns that depend on this determinant – but not the determinant itself.
Step 2:Create a new table containing all the columns from the original table that depend on this determinant.
Step 3:Make the determinant the primary key of the new table
•Customer (CustomerNum, CustomerName,Balance, CreditLimit, RepNum, LastName,FirstName)
•Customer (CustomerNum, CustomerName,Balance, CreditLimit, RepNum)
•Rep (RepNum, LastName, FirstName)
Procedure 3NF