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.

A Guide to SQL
9th Edition
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Philip J. Pratt
Chapter7: Database Administration
Section: Chapter Questions
Problem 4TD: Write, but do not execute, the commands to grant the following privileges: a. User Ashton must be...
icon
Related questions
Question


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.

INVOICE LINE
INVOICES
INVOICE NUM ITEM ID QUANTITY
QUOTED_PRICE
INVOICE NUM INVOICE DATE CUST ID
11/15/2021
11/15/2021
$37.99
S79.99
S39.99
$47.99
$18.99
S124.99
S74.99
S189.99
S19.99
S109.95
S74.95
$54.95
CA75
AD72
DT12
LD14
14216
14219
14219
14222
14224
14228
14228
14231
14216
125
227
294
182
435
125
435
14219
4.
11/16/2021
11/16/2021
11/18/2021
11/18/2021
11/18/2021
11/19/2021
14222
14224
14228
14231
14233
14237
KII81
FS42
PF19
UF39
2
1.
616
KHSI
OB92
WB49
LP73
14233
14233
14233
14237
4.
ITEM
ITEM ID DESCRIPTION
ON HAND
CATEGORY
LOCATION
PRICE
AD72
Dog Feeding Station
Feathers Bird Cage (12x24x18)
Enclosed Cat Litter Station
Dog Toy Cift Set
Fly Mask with Ears
Folding Saddle Stand
Aquarium (55 Gallon)
Wild Bird Food (25 lb)
Locking Small Dog Door
Large Pet Carrier
Pump & Filter Kit
Quilted Stable Blanket
12
DOG
BC33
CA75
DT12
FM23
FS39
FS42
S79,99
S79.99
S39,99
$39.99
10
BRD
CAT
DOG
15
27
41
12
HOR
HOR
FSH
BRD
C:
$39.99
$124.99
S19.99
$49.99
$59.99
$74.99
$119.99
S39.99
$199.99
$79.99
KH81
24
14
23
LD14
DOG
LP73
PF19
FSH
OB92
32
HOR
CAT
DOG
HOR
SP91
Small Pet Carrier
UF39
18
Underground Fence System
Insulated Water Bucket
WB49
34
FIGURE 2-1 Sample data for Kim Tou Dat O
Transcribed Image Text:INVOICE LINE INVOICES INVOICE NUM ITEM ID QUANTITY QUOTED_PRICE INVOICE NUM INVOICE DATE CUST ID 11/15/2021 11/15/2021 $37.99 S79.99 S39.99 $47.99 $18.99 S124.99 S74.99 S189.99 S19.99 S109.95 S74.95 $54.95 CA75 AD72 DT12 LD14 14216 14219 14219 14222 14224 14228 14228 14231 14216 125 227 294 182 435 125 435 14219 4. 11/16/2021 11/16/2021 11/18/2021 11/18/2021 11/18/2021 11/19/2021 14222 14224 14228 14231 14233 14237 KII81 FS42 PF19 UF39 2 1. 616 KHSI OB92 WB49 LP73 14233 14233 14233 14237 4. ITEM ITEM ID DESCRIPTION ON HAND CATEGORY LOCATION PRICE AD72 Dog Feeding Station Feathers Bird Cage (12x24x18) Enclosed Cat Litter Station Dog Toy Cift Set Fly Mask with Ears Folding Saddle Stand Aquarium (55 Gallon) Wild Bird Food (25 lb) Locking Small Dog Door Large Pet Carrier Pump & Filter Kit Quilted Stable Blanket 12 DOG BC33 CA75 DT12 FM23 FS39 FS42 S79,99 S79.99 S39,99 $39.99 10 BRD CAT DOG 15 27 41 12 HOR HOR FSH BRD C: $39.99 $124.99 S19.99 $49.99 $59.99 $74.99 $119.99 S39.99 $199.99 $79.99 KH81 24 14 23 LD14 DOG LP73 PF19 FSH OB92 32 HOR CAT DOG HOR SP91 Small Pet Carrier UF39 18 Underground Fence System Insulated Water Bucket WB49 34 FIGURE 2-1 Sample data for Kim Tou Dat O
Expert Solution
Step 1 of 2

Question 1.)

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.

trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 9 images

Blurred answer
Knowledge Booster
Database Development
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
A Guide to SQL
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
Programming with Microsoft Visual Basic 2017
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
Programming Logic & Design Comprehensive
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage