KimTay Pet Supplies database design (see Figure 2-1) to support the following requirements. A customer is not necessarily represented by a single sales rep, but they can be represented by several sales reps. When a customer places an order, the sales rep who gets the commission on the invoice must be in the collection of sales reps who represent the customer. 2. 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 requiremen

Database Systems: Design, Implementation, & Management
12th Edition
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Carlos Coronel, Steven Morris
Chapter8: Advanced Sql
Section: Chapter Questions
Problem 69C: Update the DETAILRENTAL table to set the values in DETAIL_RETURNDATE to include a time component....
icon
Related questions
Question

1.Indicate the changes (using the shorthand representation) that you would need to make to the original KimTay Pet Supplies database design (see Figure 2-1) to support the following requirements. A customer is not necessarily represented by a single sales rep, but they can be represented by several sales reps. When a customer places an order, the sales rep who gets the commission on the invoice must be in the collection of sales reps who represent the customer.

2. 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.

 

INVOICES
INVOICE LINE
INVOICE NUM INVOICE DATE CUST ID
11/15/2021
INVOICE NUM ITEM ID QUANTITY
14216
QUOTED PRICE
14216
125
CA75
$37.99
14219
11/15/2021
227
14219
AD72
$79.99
14222
11/16/2021
294
14219
DT12
4.
$39.99
14224
11/16/2021
182
14222
LD14
$47.99
14228
11/18/2021
435
14224
KH81
4.
$18.99
14231
14233
14237
11/18/2021
11/18/2021
125
14228
FS42
$124.99
435
14228
PF19
1.
$74.99
11/19/2021
616
14231
UF39
2.
S189.99
14233
KH81
$19.99
QB92
WB49
LP73
14233
$109.95
14233
$74.95
14237
$54.95
ТЕМ
ITEM ID DESCRIPTION
ON HAND
CATEGORY
LOCATION
PRICE
Dog Feeding Station
Fenthers Bird Cage (12x24x18)
AD72
12
DOG
B.
$79.99
10
BRD
B
$79.99
CA75
Enclosed Cat Litter Station
15
CAT
$39.99
Dog Toy Gift Set
Fly Mask with FRars
Folding Saddle Stand
Aquarium (55 Gallon)
DT12
27
DOG
B
$39.99
FM23
41
HOR
$24.95
FS39
12
HOR
$39.99
FS42
FSH
A.
$124.99
KHS1
LD14
Wild Bird Food (25 Ib)
24
BRD
$19.99
Locking Small Dog Door
14
DOG
$49.99
LP73
Lange Pot Carrier
23
DOG
$59.99
Pump & Filter Kit
Quilted Stable Blanket
$74.99
$119.99
PF19
FSH
A.
OB92
32
HOR
C2
SP91
Small Pet Carrier
18
CAT
B
$39.99
UF39
Underground Fence System
7.
DOG
A.
$199.99
WB49
Insulated Water Bucket
34
HOR
$79.99
Transcribed Image Text:INVOICES INVOICE LINE INVOICE NUM INVOICE DATE CUST ID 11/15/2021 INVOICE NUM ITEM ID QUANTITY 14216 QUOTED PRICE 14216 125 CA75 $37.99 14219 11/15/2021 227 14219 AD72 $79.99 14222 11/16/2021 294 14219 DT12 4. $39.99 14224 11/16/2021 182 14222 LD14 $47.99 14228 11/18/2021 435 14224 KH81 4. $18.99 14231 14233 14237 11/18/2021 11/18/2021 125 14228 FS42 $124.99 435 14228 PF19 1. $74.99 11/19/2021 616 14231 UF39 2. S189.99 14233 KH81 $19.99 QB92 WB49 LP73 14233 $109.95 14233 $74.95 14237 $54.95 ТЕМ ITEM ID DESCRIPTION ON HAND CATEGORY LOCATION PRICE Dog Feeding Station Fenthers Bird Cage (12x24x18) AD72 12 DOG B. $79.99 10 BRD B $79.99 CA75 Enclosed Cat Litter Station 15 CAT $39.99 Dog Toy Gift Set Fly Mask with FRars Folding Saddle Stand Aquarium (55 Gallon) DT12 27 DOG B $39.99 FM23 41 HOR $24.95 FS39 12 HOR $39.99 FS42 FSH A. $124.99 KHS1 LD14 Wild Bird Food (25 Ib) 24 BRD $19.99 Locking Small Dog Door 14 DOG $49.99 LP73 Lange Pot Carrier 23 DOG $59.99 Pump & Filter Kit Quilted Stable Blanket $74.99 $119.99 PF19 FSH A. OB92 32 HOR C2 SP91 Small Pet Carrier 18 CAT B $39.99 UF39 Underground Fence System 7. DOG A. $199.99 WB49 Insulated Water Bucket 34 HOR $79.99
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

Indicate the changes (using the shorthand representation) that you would need to make to the original KimTay Pet Supplies database design (see Figure 2-1) to support the following requirements. A customer is not necessarily represented by a single sales rep, but they can be represented by several sales reps. When a customer places an order, the sales rep who gets the commission on the invoice must be in the collection of sales reps who represent the customer.

Solution
Bartleby Expert
SEE SOLUTION
Knowledge Booster
Dataset
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
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programming Logic & Design Comprehensive
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage