15
5
Concepts of Database Management, 4th Edition, Pratt & Adamski
Step 1: take subset of the set of columns that make up primary key
(Order Num,
(PartNum,
(OrderNum, PartNum,
Step 2: begin a new table with this subset as the primary key
Step 3: Place each primary key of the subset with the minimal collection
of columns on which it depends.
(Order Num, OrderDate)
(PartNum,Description)
(OrderNum, PartNum, NumOrdered, Quoted Price)
Orders (OrderNum, OrderDate, PartNum, Description, NumOrdered, QuotedPrice)
To determine 2NF