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