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