In: Computer Science
a. Determine the functional dependencies that exist in the following table.
Orders (OrderNum, OrderDate, ItemNum, Description, NumOrdered, QuotedPrice)
b. After determining the functional dependencies, perform 1nf, 2nf, 3nf.
Consider relation given
Orders (OrderNum, OrderDate, ItemNum, Description, NumOrdered, QuotedPrice)
First Normal Form (1NF) :
Second Normal Form (2NF) :
Below are tables in second normal form (2NF)
1.Table Name :Item
Description :This table stores item details like ItemNum, Description
Schema :Item ( ItemNum, Description)
FD: ItemNum==>Description
2.Table Name :Orders
Description :This table stores order details like OrderNum, OrderDate
Schema :Orders( OrderNum, OrderDate)
FD: OrderNum==>OrderDate
Third Normal Form (3NF) :
Below are tables in 3NF.
1.Table Name :Item
Description :This table stores item details like ItemNum, Description
Schema :Item ( ItemNum, Description)
FD: ItemNum==>Description
2.Table Name :Orders
Description :This table stores order details like OrderNum, OrderDate
Schema :Orders( OrderNum, OrderDate)
FD: OrderNum==>OrderDate
3.Table Name :OrderDetails
Description :This table stores order details like OrderNum, and ItemNum,NumOrdered, QuotedPrice
Schema :OrderDetails( OrderNum,ItemNum, NumOrdered, QuotedPrice)
FD: OrderNum,ItemNum==>NumOrdered, QuotedPrice