WILL Rate highly, Thank you!

A distribution firm charges its clients for deliveries based on the distance between two cities. The following information is provided in the form of a SHIPMENTS relation:

SHIPPING CODE	ORIGIN	DESTINATION	CHARGE
BR695-211	Toronto	Ottawa	$450
BR421-512	Ottawa	Vancouver	$4,359
BR612-623	Toronto	Sudbury	$422
BR981-675	Vancouver	Winnipeg	$2,344
BR512-913	Ottawa	Toronto	$450

a) Develop a diagram showing the functional dependencies in the SHIPMENTS relation.

b) Is SHIPMENTS in 3NF?

i) If yes, explain your reasoning and leave the relation as is !

ii) If No, explain which normal form you believe the relation to be in, and convert it to third normal form. Show the resulting relation(s) with the sample data presented in SHIPMENTS.