Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Open a new Microsoft Word document and answer the following question. Save the file on your computer with your last name in the file name.
- Open a new Microsoft Word document and answer the following question.
- Save the file on your computer with your last name in the file name. (Example: Case_Exercise_1 _Jones.doc)
- Click the Choose File button to find and select your saved document.
Indicate the changes (using the shorthand representation) that you would need to make to the original KimTay Pet Supplies database design to support the following requirements.
There is no relationship between customers and sales reps. When a customer places an order, any sales rep can process the order and create the invoice. On the invoice, you need to identify both the customer placing the order and the sales rep responsible for the invoice. Draw an E-R diagram for the new design.
125 INVOICES INVOICE_LINE INVOICE_NUM INVOICE DATE CUST_ID INVOICE_NUM ITEM_ID QUANTITY QUOTED_PRICE 14216 11/15/2021 14216 CA75 3 $37.99 14219 11/15/2021 227 14219 AD72 2 $79.99 14222 11/16/2021 294 14219 DT12 $39.99 14224 11/16/2021 182 14222 LD14 1 $47.99 14228 11/18/2021 435 14224 KH81 4 $18.99 14231 11/18/2021 125 14228 FS42 1 $124.99 14233 11/18/2021 435 14228 PF19 1 $74.99 14237 11/19/2021 616 14231 UF39 2 $189.99 14233 KH81 1 $19.99 14233 QB92 $109.95 14233 WB49 4 $74.95 14237 LP73 $54.95 C ITEM ITEM_ID DESCRIPTION ON_HAND CATEGORY LOCATION AD72 Dog Feeding Station 12 DOG B BC33 Feathers Bird Cage (12x24x18) 10 BRD B CA75 Enclosed Cat Litter Station 15 CAT DT12 Dog Toy Gift Set 27 DOG B FM23 Fly Mask with Ears 41 HOR FS39 Folding Saddle Stand 12 HOR FS42 Aquarium (55 Gallon) 5 FSH KH81 Wild Bird Food (25 lb) 24 BRD LD14 Locking Small Dog Door 14 DOG A LP73 Large Pet Carrier 23 DOG B PF19 Pump & Filter Kit 5 FSH A QB92 Quilted Stable Blanket 32 HOR SP91 Small Pet Carrier 18 CAT B UF39 Underground Fence System 7 DOG A WB49 Insulated Water Bucket 34 HOR FIGURE 2-1 Sample data for Kim Tay Pet Supplies (Continued) PRICE $79.99 $79.99 $39.99 $39.99 $24.95 $39.99 $124.99 $19.99 $49.99 $59.99 $74.99 $119.99 $39.99 $199.99 $79.99 CStep 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