Table 4-8 shows a portion of a shipment table for a large manufacturing company. Each shipment (identified
Question:
Table 4-8 shows a portion of a shipment table for a large manufacturing company. Each shipment (identified by Shipment#) uniquely identifies the shipment Origin, Destination, and Distance. The shipment Origin and Destination pair also uniquely identifies the Distance.
a. Develop a diagram that shows the functional dependencies in the SHIPMENT relation.
b. In what normal form is SHIPMENT? Why?
c. Convert SHIPMENT to third normal form if necessary.
Show the resulting table(s) with the sample data presented in SHIPMENT.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Essentials of Database Management
ISBN: 978-0133405682
1st edition
Authors: Jeffrey A. Hoffer, Heikki Topi, Ramesh Venkataraman
Question Posted: