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...
-
Income statement and schedule of cost of goods manufactured. The Howell Corporation has the following account balances (in millions): Prepare an income statement and a supporting schedule of cost of...
-
Under what circumstances would adherence to an inflation target lead to (a) more stable interest rates, (b) less stable interest rates than pursuing discretionary demand management policy?
-
Refer to the data in Exercise 10-24. Required a. How can RSB&T use the information from the activity-based costing analysis to manage its costs? b. What does RSB&T need to consider before...
-
A securities market operating in a country without government bonds has many assets each with a different daily return. If you have data on daily returns for all the assets, explain with the help of...
-
Reference frame S is moving along the x axis at 0.6c relative to frame S. A particle that is originally at x = 10 m at t 1 = 0 is suddenly accelerated and then moves at a constant speed of c/3 in...
-
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...
-
In the opening highlight, what barrier might you have (or imagine) to designating a sober skipper?
-
Solve 12 [9(x). g(x) dx
-
Dads restaurant serves three different sandwiches to customers, Ham, turkey and vegetable sandwiches. The ingredients for the ham sandwich cost $1.20, for the turkey sandwich $1.10 and the vegetable...
-
Assume we have a $500,000 mortgage at 3.5% original interest rate, with a 30 year term and monthly payments. The interest rate can be adjusted at the end of each year, and we assume the rate...
-
GloboCorp Industries has hired you to help price a so called "reverse convertible bond" that they are considering issuing as part of a recapitalization. GloboCorp is currently all-equity financed,...
-
At what point are a nonqualified annuity's earnings subject to inco?Explain. Ten years ago, John purchased a deferred annuity and named his da invested $50,000 in the contract; upon his death, the...
-
Think of your current or previous employer, and describe what types of control systems they had in place. In your opinion, are they the right ones?
-
Suppose the concentration of glucose inside a cell is 0.1 mm and the cell is suspended in a glucose solution of 0.01 mm. a. What would be the free energy change involved in transporting 10-o mole of...
-
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),...
-
What are the various methods available for managing one's accounts? Explain with example
-
Blue Sky Corporation, a U.S.-based company, invested 11 million Polish zloty in Green Mountain Company in Lodz, Poland, on January 1, Year 2, when the exchange rate for the Polish zloty (PLN) was...
-
You are working as a Delivery Driver at Yellow Chicken Clothing Store. Your salary is $19.23 per hour and you work 40 hours per week. You have always wanted to be your own boss, but could never...
Study smarter with the SolutionInn App