Table 4-5 shows a shipping manifest. Your assignment is as follows: a. Draw a relational schema and
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. 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).
Transcribed Image Text:
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
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 37% (8 reviews)
a Total weight is a derived attribute and can be calculated fr...View the full answer
Answered By
Hemstone Ouma
"Hi there! My name is Hemstone Ouma and I am a computer scientist with a strong background in hands-on experience skills such as programming, sofware development and testing to name just a few. I have a degree in computer science from Dedan Kimathi University of Technology and a Masters degree from the University of Nairobi in Business Education. I have spent the past 6 years working in the field, gaining a wide range of skills and knowledge. In my current role as a programmer, I have had the opportunity to work on a variety of projects and have developed a strong understanding of several programming languages such as python, java, C++, C# and Javascript.
In addition to my professional experience, I also have a passion for teaching and helping others to learn. I have experience as a tutor, both in a formal setting and on a one-on-one basis, and have a proven track record of helping students to succeed. I believe that with the right guidance and support, anyone can learn and excel in computer science.
I am excited to bring my skills and experience to a new opportunity and am always looking for ways to make an impact and grow as a professional. I am confident that my hands-on experience as a computer scientist and tutor make me a strong candidate for any role and I am excited to see where my career will take me next.
5.00+
8+ Reviews
22+ Question Solved
Related Book For
Essentials of Database Management
ISBN: 978-0133405682
1st edition
Authors: Jeffrey A. Hoffer, Heikki Topi, Ramesh Venkataraman
Question Posted:
Students also viewed these Computer science 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...
-
Using Porter's Five Forces Model, examine the impact of the market positioning on the selected product or service. Describe how each of the forces provides an advantage and disadvantage to the...
-
Suppose at the beginning of 2006 you decide to invest $1,000 in Vanguard's European Stock Index mutual fund. The following table shows the returns for the years 2006-2009. Year Annual Return...
-
(a) Sketch the graph of the function, highlighting the part indicated by the given interval, (b) Write a definite integral that represents the arc length of the curve over the indicated interval and...
-
Chevron Phillips (CP) has put into place new laboratory equipment for the production of chemicals; the cost is \($1,800,000\) installed. CP borrows 45 percent of all capital needed, and the borrowing...
-
Byte Computer Company, a manufacturing organization, has just completed an order that Grater, Ltd., placed for 80 computers. Direct materials, purchased parts, and direct labor costs for the Grater...
-
Explain how firms that are price-makers and choose the price that maximizes total profits can still make economic losses. (8marks) Under what conditions will firms making economic losses choose not...
-
Sunny Best is the engagement partner for the financial report audit of BigMac Ltd for the year ended 31 December, 2021. The following material events or transactions have come to Sunny Bests...
-
Transform the relational schema developed in Problem and Exercise 9 into an EER diagram. State any assumptions that you have made.
-
Fill in the blanks in each of the following statements: a. A relation that has no partial functional dependencies is in _____ normal form. b. A relation that has no transitive dependencies is in...
-
H& R Block, a tax preparation company, believes that the median tax refund for 2014 was greater than $ 3,000. To test this belief, the following random sample of 2014 re-funds was collected. These...
-
Before a party can bring a lawsuit, what must the party have?
-
Arturo signs Beths name, without her consent, to the back of a check payable to Beth. This is a. burglary. b. embezzlement. c. forgery. d. larceny.
-
David Zigler was an employee of Featherstone Foods. Joel Schonfeld was Ziglers employer. The two exchanged e-mails in which Zigler sought assurance that he would have a right of first refusal to...
-
Fraudulently altering a public document can be forgery. (True/False)
-
The statutory law of the United States includes a. the statutes enacted by Congress and state legislatures. b. the rules, orders, and decisions of administrative agencies. c. both the statutes...
-
How does a five-year summary of historical results help investors?
-
MgO prevents premature evaporation of Al in a furnace by maintaining the aluminum as Al2O3. Another type of matrix modifier prevents loss of signal from the atom X that readily forms the molecular...
-
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),...
-
Describe the process of depth-first search (DFS) and provide a Python implementation to traverse a graph using DFS.
-
A number like 197 is called a **Fare prime** because when all of its digits are rotated (197, 971 and 719), each new number is also prime. Help me a code that can find all fare primes up to a...
-
Required: 1. Determine the inventory on March 31 and the cost of merchandise sold for the three-month period, using the first-in, first-out method and the periodic inventory system. Merchandise...
Study smarter with the SolutionInn App