Organize the following in third normal formation 3nF CustID

Organize the following in third normal formation (3nF)

Solution

For a relation to be in 3rd normal form ,all values in the table should be atomic(1st normal form), all non key attributes should be fully functionally dependent on the key attributes(2nd Normal Form) and there should not be transitive dependencies.(3rd normal form)

The functional dependencies of the relation are as under:

Cust_ID ---> Cust_F_Name

Cust_ID ---> Cust_L_Name

Cust_ID ---> Cust_Street_Addr

Cust_ID ---> Cust_City

Cust_ID ---> Cust_State

Cust_ID ---> Cust_Zip

Cust_ID ---> Cust_Phone

Ord_Num ---> Ord_Date

Ord_Num ---> Ship_Date

Ord_Num ---> Deliver_Date

Shipper_Name ----> Shipper_Street_Address

Shipper_Name ----> Shipper_Name

Shipper_Name ----> Shipper_City

Shipper_Name ----> Shipper_State

Shipper_Name ----> Shipper_Zip

Shipper_Name ----> Shipper_Phone

Shipper_Name ----> Shipper_URL

Item_Num ----> Item_Descr

Item_Num ----> Item_Price

Item_Num ----> Item_Quantity

Salesperson_ID ----> Salesperson_F_name

Salesperson_ID ----> Salesperson_F_name

Tables in 3NF

CUSTOMER(Cust_ID,Cust_F_Name,Cust_L_Name,Cust_Street_Addr, Cust_City, Cust_State, Cust_Zip,Cust_Phone)

ORDERS(Ord_Num ,Ord_Date, Ship_Date,Deliver_Date)

SHIPPER(Shipper_Name ,Shipper_Street_Address,Shipper_City,Shipper_State, Shipper_Zip,Shipper_Phone, Shipper_URL)

ITEM(Item_Num ,Item_Descr, Item_Price,Item_Quantity)

SALESPERSON(Salesperson_ID ,Salesperson_F_name, Salesperson_L_name)