Answered step by step
Verified Expert Solution
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 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...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started