Answered step by step
Verified Expert Solution
Question
1 Approved Answer
2. Use the Invoice table structure shown below to answer the following questions: INVOICE Item Cust Retail INV# CustId PetID ItemID Cust Phone Qtyo Desc
2. Use the Invoice table structure shown below to answer the following questions: INVOICE Item Cust Retail INV# CustId PetID ItemID Cust Phone Qtyo Desc Name Price T10 C455 P81 T23 C623 P52 T10 | C455 P81 T16 0138 P78 T90206 P94 112 Collar Elliot 164 Toy DuBarry 1413 Leash Elliot 1511 Dish Travers 183 Chews Allen 5558776987 9.57 5550897543 3.29 5558776987| 14.98 5554379533 8.55 5552659980 5.99 15 45 34 25 86 Qty Purchase PetName Breed Purchased date i | 12/15/2015 Digger Lab 2 1/5/2016 Nubs Beagle 2 12/15/2015 Digger Lab 2 11/25/2015 Snuggles Poodle 5 11/30/2015 Snoops Hound a. (5) Draw the dependency diagram identifying all dependencies (given/hidden). You can assume that the table does not contain repeating groups (INF). b. (3) Improve the relation to 2NF. Show the new FDs and all dependency arrows. Identify the primary keys. c. (5) Improve to 3NF. Show the new FDs and all dependency arrows. Identify the primary keys. d. (9) Draw the relational schema for the final database table structure. Identify all primary/foreign keys
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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