Question: 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.

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.
e. Draw your answer to part d using Microsoft Visio (or any other tool specified by your instructor).

TABLE 4-5 Shipping Manifest Shipment ID: Shipment Date: 00-0001 01/10/2012 Expected Arrival: Origin: Boston 01/14/2012 B

TABLE 4-5 Shipping Manifest Shipment ID: Shipment Date: 00-0001 01/10/2012 Expected Arrival: Origin: Boston 01/14/2012 Brazil Destination: Ship Number: 002-15 39 Captain: Henry Moore Item Number Description Weight Quantity Type TOTALWEIGHT 3223 BM Concrete 500 100 50,000 Form Steel 3297 87 2,000 174,000 Beam Shipment Total: 224,000

Step by Step Solution

★★★★★

3.38 Rating (160 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a Total weight is a derived attribute and can be calculated fr... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Essentials Database Management Questions!

Using Microsoft Visio or other diagraming software a. Prepare an annotated table of entities and activities based on the output from Short Problems 4-1 and 4-2. Indicate on this table the groupings,...

Analyze and document the functional dependencies in each relation identified in 463 above If any relation is not in 3NF, decompose it into 3NF, using the steps described in this chapter Revise your...

1. Using Microsoft Visio or an open source alternative such as Dia, create a use case graphic rendering that shows all actors and all use cases for the RMO CSMS marketing subsystem. Note: The...

DATABASE MANEGEMENT 4-37 Table below 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...

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....

Table 4-5 shows an invoice for an order. Your assignment is as follows: A) Draw a relational schema and diagram the functional dependencies B) in what normal form is this relation? C) decompose...

The following table contains sample data for parts and for vendors who supply those parts. In discussing these data with users, we find that part numbers (but not descriptions) uniquely identify...

Masoner Savings, headquartered in a small community, holds most of its correspondent deposits with Flagg Metrocenter Bank, a money center institution. When Masoner has a cash surplus in its...

Hewlett-Packard Corporation (HP) designs, manufactures, and distributes computer systems and imaging and printing products and offers information technology services. The company's offerings span IT...

Over the past 24 months, Allen Company has found that overhead was consistently overapplied and the company had begun to lose jobs. Allen will adjust the predetermined overhead rate so that applied...

Describe the process you would use to develop a plan to direct the use of scarce resources during a pandemic.

The min method for the UnsortedPriorityQueue class executes in O(n) time, as analyzed in Table 9.2. Give a simple modification to the class so that min runs in O(1) time. Explain any necessary...

An airport is developing a computer simulation of air-traffic control that handles events such as landings and takeoffs. Each event has a time stamp that denotes the time when the event will occur....

What does each removeMin call return within the following sequence of priority queue ADT operations: insert(5, A), insert(4, B), insert(7, F), insert(1, D), removeMin( ), insert(3, J), insert(6, L),...

150 people are asked how many siblings they have? # of Siblings Frequency |Relative Frequency |Cumulative Frequency O 0.2533 38 28 0. 1867 2 32 0.2133 98 W 22 120 4 30 0.2 150 a. Complete the table...

can you please assist in the following Profit and Loss Statement ( projected for year 2 ) Monthly Cash Flow Sensitivity Analysis Balance Sheet ( at year - end )

Stock. java public class Stock { private String name; /ame of company private String symbol; //Symbol of company on Stock Exchange private double price; //price per share private int shares; /umber...