Normalization Assignment

Normalize the following relations. Show possible candidate keys and the functional

dependencies. Explain the normal form in which the relation is currently in $($based on the

sample data$)$ and how do you break the relations to get $3^{rd}$ Normal Form. Show the new

relations obtained after normalization and underline the candidate$/$primary key in each new

relation.

Relation $1$:

SHIPMENT $($Shipment#$,$ Origin, Destination, Distance$)$

$($Illustrated with sample data$)$

Relation $2$:

PART SUPPLIER $($PartNo$,$ Description, VendorName, Address, UnitCost$)$

$($Illustrated with sample data$)$