Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You have to normalize database tables to 3rd Normal form for the data presented in the next page The data represents sales transaction details.

You have to normalize database tables to 3rd Normal form for the data presented in the next page The data 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 

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Answer Yes I identified the following derived attributes in the image Total This attribute can be ca... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516

More Books

Students also viewed these Databases questions

Question

The NEXT REFUEL box displays what three things?

Answered: 1 week ago

Question

8. What kinds of people are most likely to develop sleep apnea?

Answered: 1 week ago