A distribution firm charges its clients for deliveries based on the distance between two cities. The following
Question:
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:
SHIPMENT CODE Origin Destination Charge
AC695-211 Toronto Ottawa $450
AC421-512 Ottawa Vancouver $4,359
AC612-623 Toronto Sudbury $422
AC981-675 Vancouver Winnipeg $2,344
AC512-931 Ottawa Toronto $450
a) Develop a diagram showing the functional dependencies in the SHIPMENTS relation.
b) Is SHIPMENTS in 3NF?
a. If yes, explain your reasoning and leave the relation as is!
b. If No, explain which normal form you believe the relation to be in, and convert it to the third normal form. Show the resulting relation(s) with the sample data presented in SHIPMENTS.
Financial Reporting Financial Statement Analysis and Valuation a strategic perspective
ISBN: 978-1337614689
9th edition
Authors: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw