Q: 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.
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.
e. Draw your answer to part d using Microsoft Visio (or any other tool specified by your instructor).
.png)
TABLE 4-5 Shipping Manifest Shipment ID: Origin Destination Ship Number Shipment Date Expected Arrival 01/10/2015 00-0001 Boston Brazil 39 01/14/2015 002-15 Henry Moore TOTALWEIGHT Captain: ltem Number Type Description Weight Quantity 3223 100 50,000 Concrete Form Steel eam BM 500 3297 BM 87 2,000 174,000 Shipment Total: 224,000
Step by Step Solution
3.44 Rating (179 Votes )
There are 3 Steps involved in it
Step: 1
Transforming Table 45 shipping manifest to relations a Total weight is a derived ... View full answer

Get a step-by-step solution from a verified subject matter expert – not AI-generated answers
Step: 2Unlock detailed examples and clear explanations to master concepts

Step: 3Unlock to practice, ask and learn with real-world examples

Document Format ( 1 attachment)

613-CS-DB (1686).docx
120 KBs Word File
See step-by-step solutions with expert insights and AI powered tools for academic success
-
Access 30 Million+ textbook solutions.
-
Ask unlimited questions from AI Tutors.
-
24/7 Expert guidance tailored to your subject.
-
Order free textbooks.
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Study Smart with AI Flashcards
Access a vast library of flashcards, create your own, and experience a game-changing transformation in how you learn and retain knowledge
Explore Flashcards