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)

Shipment#	Origin	Destination	Distance
409	Seattle	Denver	1330
618	Chicago	Dallas	960
723	Boston	Atlanta	1100
824	Denver	Los Angeles	100
629	Seattle	Denver	1330

Relation 2:

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

(Illustrated with sample data)

PartNo	Description	VendorName	Address	UnitCost
1234	Logic Chip	Fast Chips	Cupertino	10.00
1234	Logic Chip	Smart Chips	Phoenix	8.00
5678	Memory Chip	Fast Chips	Cupertino	3.00
5678	Memory Chip	Quality Chips	Austin	2.00
5678	Memory Chip	Smart Chips	Phoenix	5.00