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: 44% (9 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...
-
Think about a competitive market in which you participate regularly. For each of the characteristics of a competitive market, explain how your market meets these requirements.
-
What is the scope of the discovery?
-
Each year, ratings are compiled concerning the performance of new cars during the first 90 days of use. Suppose that the cars have been categorized according to whether a car needs warranty-related...
-
Question: The expectation gap is the difference between what the public perceived as the responsibilities of accountants and _____. A. What accountants see as their responsibilities B. What managers...
-
Artemis is paid a weekly commission of 4% on net sales of $6000, 8% on the next $3000, and 12.5% on all further sales. Her gross sales for a week were $11 160, and sales returns and allowances were...
-
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 a city, the price for a trip on local mass transit (such as the subway or city buses) has been 10 pesos for a number of years. Suppose that the market for trips is characterized by the following...
-
Guy Holcomb owns and operates Oasis Goodtime Emporium, an adult entertainment establishment. Holcomb wanted to create an adult Internet system for Oasis that would offer customers adult-theme videos...
-
Developing Ltd has an authorized capital of 100,000, 8% preference shares of 1 each and 400,000 ordinary shares of 50p each. After preparation of the statement of profit or loss for 2017, the...
-
What are the components of a time-series model? When does an annual time series require smoothing? Explain the moving average method of smoothing time series data and forecasting.
-
What is the importance of business forecasting?
-
The trial balance extracted from the books of Tailor Times Ltd at 31 December 2016 was as follows: You are given the following additional information: (1) The authorized and issued share capital is...
-
In an R-C circuit, a resistor, an uncharged capacitor, a dc battery, and an open switch are in series. In an R-L circuit, a resistor, an inductor, a dc battery, and an open switch are in series....
-
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),...
-
Outdoor Luggage, Incorporated, makes high-end hard-sided luggage for sports equipment. Data concerning three of the company's most popular models appear below. Ski Guard Selling price per unit $ 270...
-
Jury nullification can be defined as when the jury refuses to convict a defendant who is legally guilty of the crime. This typically occurs when a jury finds that the law is unjust or that the...
-
21. (5 points) Write code snippet to find the smaller number of two integers. int num1 = input.nextInt(); int num2=input.nextInt(): int smaller; // your code here 22. (5 points) Write code snippet to...
Study smarter with the SolutionInn App