You have to normalize database tables to 3rd Normal form for the data presented in the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You have to normalize database tables to 3rd Normal form for the data presented in the next page The data represents sales transaction details. Deliverables include the following: 1. Dependency diagram of the table after converting to 1NF indicating all the dependencies 2. Dependency diagram for each table after converting to 2NF indicating all the dependencies 3. Dependency diagrams of each table after converting to 3NF indicating all the dependencies 4. Create normalized fully attributed Entity Relationship diagram in MS Visio showing all the entities, their relationships, and cardinalities (Add additional attributes to each table as appropriate: Make sure not to end up de-normalizing the tables in the process). 5. Answer these specific questions: a. How will you maintain historical accuracy of "product price? b. Did you identify any derived attribute? If yes, how did you handle it? Note: You need to upload to Moodle before the due date and time the following: MS Word document showing items 1, 2, 3, and 5 above (You could use Word features such as Insert Table, and Insert Shapes tools to draw the dependency diagram-A sample drawing is shown in page 3) MS Visio file showing item 4 above Order ID 1001 1004 1005 1010 1007 1002 1003 1006 1009 1008 10573 Cust Type 2 2 3 2 3 1 3 vt 3 2 3 Sust Name Type Gold Gold Platinum Gold Platinum Silver Platinum Silver Platinum Gold Platinum Cust ID 103 103 102 103 101 102 101 102 104 105 Cust Name John Adams John Adams Sara Matthews John Adams Rick Scott Liz Thong Rick Scott Liz Thong Tony Hernandez Neal Katyal State TX TX TX TX MO MO MO MO CA CA 104 Tony Hernandez CA Prod.ID 34 56 78 33 23 35 63 34 56 23 14 63 14 63 78 34 14 72 56 33 23 35 23 34 63 35 78 33 Prod Name Black pepper Garlic powder Hakka Noodles Mustard sauce Paprika Soy Sauce Vegie-spread Black pepper Garlic powder Paprika Tofu Vegie-spread Tofu Vegie-spread Hakka Noodles Black pepper Tofu Mozzarella sticks Garlic powder Mustard sauce Paprika Soy Sauce Paprika Black pepper Vegie-spread Soy Sauce Hakka Noodles Mustard sauce Unit_ Price 13.25 14.25 22.00 12.00 12.00 11.00 21.00 13.25 14.25 12.00 8.50 21.00 8.50 21.00 22.00 13.25 8.50 34.80 4.25 12.00 12.00 11.00 12.00 13.25 21.00 11.00 22.00 12.00 Qty. Tax_ Rate 7.25% 12 ++ 4 4 5 00 m + 8 3 4 5 6 Nm in m 2 3 7.25% 6.00% 6.00% 3 6.00% 6.00% 5 2 2 6.00% 6.00% 6.00% 6.00% .00% 6.00% 8.25% 8.25% 8.25% 8.25% 8.25% 8.25% 8.25% 8.25% 5 7.25% 7.25% 7.25% 7.25% 7 2 3 5 24 50 1 5 6 5 9 25 7.25% 7.25% 7.25% 7.25% Total 170.53 61.13 94.38 64.35 102.96 35.39 90.09 71.05 91.70 25.74 27.03 111.30 27.03 111.30 46.64 28.09 63.07 73.78 45.32 63.60 311.76 595.38 12.99 71.72 136.40 59.54 214.34 324.75 You have to normalize database tables to 3rd Normal form for the data presented in the next page The data represents sales transaction details. Deliverables include the following: 1. Dependency diagram of the table after converting to 1NF indicating all the dependencies 2. Dependency diagram for each table after converting to 2NF indicating all the dependencies 3. Dependency diagrams of each table after converting to 3NF indicating all the dependencies 4. Create normalized fully attributed Entity Relationship diagram in MS Visio showing all the entities, their relationships, and cardinalities (Add additional attributes to each table as appropriate: Make sure not to end up de-normalizing the tables in the process). 5. Answer these specific questions: a. How will you maintain historical accuracy of "product price? b. Did you identify any derived attribute? If yes, how did you handle it? Note: You need to upload to Moodle before the due date and time the following: MS Word document showing items 1, 2, 3, and 5 above (You could use Word features such as Insert Table, and Insert Shapes tools to draw the dependency diagram-A sample drawing is shown in page 3) MS Visio file showing item 4 above Order ID 1001 1004 1005 1010 1007 1002 1003 1006 1009 1008 10573 Cust Type 2 2 3 2 3 1 3 vt 3 2 3 Sust Name Type Gold Gold Platinum Gold Platinum Silver Platinum Silver Platinum Gold Platinum Cust ID 103 103 102 103 101 102 101 102 104 105 Cust Name John Adams John Adams Sara Matthews John Adams Rick Scott Liz Thong Rick Scott Liz Thong Tony Hernandez Neal Katyal State TX TX TX TX MO MO MO MO CA CA 104 Tony Hernandez CA Prod.ID 34 56 78 33 23 35 63 34 56 23 14 63 14 63 78 34 14 72 56 33 23 35 23 34 63 35 78 33 Prod Name Black pepper Garlic powder Hakka Noodles Mustard sauce Paprika Soy Sauce Vegie-spread Black pepper Garlic powder Paprika Tofu Vegie-spread Tofu Vegie-spread Hakka Noodles Black pepper Tofu Mozzarella sticks Garlic powder Mustard sauce Paprika Soy Sauce Paprika Black pepper Vegie-spread Soy Sauce Hakka Noodles Mustard sauce Unit_ Price 13.25 14.25 22.00 12.00 12.00 11.00 21.00 13.25 14.25 12.00 8.50 21.00 8.50 21.00 22.00 13.25 8.50 34.80 4.25 12.00 12.00 11.00 12.00 13.25 21.00 11.00 22.00 12.00 Qty. Tax_ Rate 7.25% 12 ++ 4 4 5 00 m + 8 3 4 5 6 Nm in m 2 3 7.25% 6.00% 6.00% 3 6.00% 6.00% 5 2 2 6.00% 6.00% 6.00% 6.00% .00% 6.00% 8.25% 8.25% 8.25% 8.25% 8.25% 8.25% 8.25% 8.25% 5 7.25% 7.25% 7.25% 7.25% 7 2 3 5 24 50 1 5 6 5 9 25 7.25% 7.25% 7.25% 7.25% Total 170.53 61.13 94.38 64.35 102.96 35.39 90.09 71.05 91.70 25.74 27.03 111.30 27.03 111.30 46.64 28.09 63.07 73.78 45.32 63.60 311.76 595.38 12.99 71.72 136.40 59.54 214.34 324.75
Expert Answer:
Answer rating: 100% (QA)
Answer Yes I identified the following derived attributes in the image Total This attribute can be ca... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these databases questions
-
Inflation and Exchange Rates Go to www.marketvector.com and follow the Exchange Rates link. Select the Australian Dollar link. Is the U.S. dollar expected to appreciate or depreciate compared to the...
-
Why is it important for hospitality managers to understand basic accounting practices?
-
Company XYZ invested $50,000 in a marketing campaign that resulted in generating additional sales of $200,000. The company's operating expenses for the campaign were $20,000. Calculate the Return on...
-
8 D D D D P P P P P P P P P P P 10 Functions What is defusion. What is osnosis What is Tornicity The power house of the cell functions of the plasma? What is facilitated defusion? do they need ATP?...
-
Calculate the period of small oscillations of a hydrometer (Fig. 4.2) which was slightly pushed down in the vertical direction. The mass of the hydrometer is m = 50 g, the radius of its tube is r =...
-
A bakery in a remote town faces essentially no competition. The weekly demand for its famous morning buns is given by 800 - 200p, where p is the price per bun. Currently, the bakery is charging $2.55...
-
Explain the four phases of the Rapid Application Development (RAD) methodology. How do they differ from the traditional SDLC approach?
-
1. How does virtualization work? In your own words, describe what you understand about the virtualization process as depicted in the case. 2. In software development and testing, where does...
-
[1] In Calculus, it can be proven that Write a MATLAB script that approximates this infinite series by a finite such that the absolute error falls below a certain tolerance entered by the user. For...
-
A shaft is to be designed to support the spur pinion and helical gear shown in the figure on two bearings spaced 700 mm center-to-center. Bearing A is a cylindrical roller and is to take only radial...
-
Suppose Joe has just entered into a long position of 6-month forward contract on a dividendpaying stock when the stock price is $55. The stock is expected to pay dividends of $0.5 per share in 1...
-
How does the requirement of consent for collection, use, and disclosure of personal information differ in the public and private sectors?
-
Employee ____________ is the loss or turnover of employees to other jobs and industries perceived as having healthier workplace cultures.
-
What factors influence jurisdiction over an internet libel case?
-
Visit Young Entrepreneur on Twitter (@YoungEnt). These young professionals have used speech design to become effective communication professionals. What can you learn from their social media presence?
-
What steps should be followed by a business considering outsourcing data processing to an American company?
-
Which of the following statements about semaphores is true? a) P and V operations should be indivisible operations. b) If several threads attempt a P( S ) operation simultaneously,only one thread...
-
Use this circle graph to answer following Exercises. 1. What fraction of areas maintained by the National Park Service are designated as National Recreation Areas? 2. What fraction of areas...
-
a. Wilson filed his individual tax return on the original due date, but failed to pay $700 in taxes that were due with the return. If Wilson pays the taxes exactly 2 months late, calculate the amount...
-
Linda and Richard are married and file a joint return for 2012. During the year, Linda, who works as an accountant for a national airline, used $2,100 worth of free passes for travel on the airline;...
-
On July 1, 2012, Ted, age 73 and single, sells his personal residence of the last 30 years for $365,000. Ted's basis in his residence is $35,000. The expenses associated with the sale of his home...
-
What is the primary business of Satyam Computer Services Ltd?
-
In January 2009, approximately how many employees did Satyam Computer Services employ?
-
What was the cash balance sheet amount and how much cash actually existed in the Satyams bank accounts?
Study smarter with the SolutionInn App