Ņ 5. Table 4-5 shows a shipping manifest. Your assignment is as follows: a. Draw a relational schema and diagram the functional dependencies in the relation. b. In what normal form is this relation? + c. Decompose MANIFEST into a set of 3NF relations. d. Draw a relational schema for your 3NF relations and show the referential integrity constraints. TABLE 4-5 Shipping Manifest 00-0001 Boston Brazil 39 Shipment ID: Origin: Destination: Ship Number: Item Number 3223 3297 Type BM BM Description Concrete Form Steel Beam Shipment Date: Expected Arrival: Captain: Weight 500 87 Quantity 100 2,000 Shipment Total: 01/10/2010 01/14/2010 002-15 Henry Moore TOTALWEIGHT 50,000 174,000 224,000 Ņ5. Table 4-5 shows a shipping manifest. Your assignment is as follows:a. Draw a relational schema and diagram the functional dependencies in the relation.b. In what normal form is this relation? +c. Decompose MANIFEST into a set of 3NF relations.d. Draw a relational schema for your 3NF relations and show the referential integrity constraints.TABLE 4-5 Shipping Manifest00-0001BostonBrazil39Shipment ID:Origin:Destination:Ship Number:Item Number32233297TypeBMBMDescriptionConcreteFormSteelBeamShipment Date:Expected Arrival:Captain:Weight50087Quantity1002,000Shipment Total:01/10/201001/14/2010002-15Henry MooreTOTALWEIGHT50,000174,000224,000

a. Relational Schema and Functional Dependencies:Here is the relational schema for the Shipping…

Answered: Ņ 5. Table 4-5 shows a shipping…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

Ņ 5. Table 4-5 shows a shipping manifest. Your assignment is as follows: a. Draw a relational schema and diagram the functional dependencies in the relation. b. In what normal form is this relation? + c. Decompose MANIFEST into a set of 3NF relations. d. Draw a relational schema for your 3NF relations and show the referential integrity constraints. TABLE 4-5 Shipping Manifest 00-0001 Boston Brazil 39 Shipment ID: Origin: Destination: Ship Number: Item Number 3223 3297 Type BM BM Description Concrete Form Steel Beam Shipment Date: Expected Arrival: Captain: Weight 500 87 Quantity 100 2,000 Shipment Total: 01/10/2010 01/14/2010 002-15 Henry Moore TOTALWEIGHT 50,000 174,000 224,000