Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

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

Case Studies In Business Data Bases

Authors: James Bradley

1st Edition

0030141346, 978-0030141348

More Books

Students also viewed these Databases questions

Question

Persuasive Speaking Organizing Patterns in Persuasive Speaking?

Answered: 1 week ago