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

1 Expert Approved Answer

Step: 1 Unlock

Transforming Table 45 shipping manifest to relations a Total weight is a derived ... 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

Document Format (1 attachment)

613-CS-DB (1686).docx

120 KBs Word File

Students Have Also Explored These Related Databases 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...

The local Holiday Inn collected seven months of data on the number of room- nights rented per month and the monthly utilities cost. The data were graphed, resulting in the following scatter plot: 1....

"Office equipment was acquired by issuing 170 common shares. The shares are actively traded and had a closing market price a few days before the office equipment was acquired of $12 per share....

Many grandparents name their grandchildren as the beneficiaries of their life insurance policies. How should the life insurance policies for the benefit of grandchildren be held? Group of answer...

Classifi cation of Financial Statement Items Carnival Corporation & plc is one of the largest cruise companies in the world with such well-known brands as Carnival Cruise Lines, Holland America Line,...

Consider the example on page 435, which shows that there is no need for deswizzling if hardware swizzling is used. Explain why, in that example, it is safe to change the short identifier of page...

When is it preferable to use a dense index rather than a sparse index? Explain your answer. Discuss.

Since indices speed query processing, why might they not be kept on several search keys? List as many reasons as possible. Discuss.

Bond returns Last year, Joan purchased a $1,000 face value corporate bond with an 7% annual coupon rate and a 25-year maturity. At the time of the purchase, it had an expected yield to maturity of...

Consider the same loan; $ 6 0 0 , 0 0 0 SOy fixed rate mortgage with a 7 % interest rate, paid monthly ( hint bulld an amortization tabla in excel ) : a . What is the monthly payment on this loan? b...

The 1999 Balance Sheet for ABC Corporation is shown below: The firm is currently operating at 100% capacity with sales of $100,000. Management believe that next year sales will increase by 10% and it...