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.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
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.

Answer each of the following questions using the KimTay Pet Supplies data shown in Figure 2-1.
SALES REP
REP_ID FIRST NAME LAST NAME
Garcia
Miller
Smith
Jackson
05
10
15
20
CUSTOMER
CUST_FIRST_ LAST
NAME
Smith
ID
125
182
227
294
314
435
492
543
Susan
Richard
Donna
Daniel
616
721
NAME
Joey
Billy
Sandra
375 Melanie Jackson
Tom
Samantha Smith
James
Elmer
Angle
Sally
Rufton
Leslie
Pincher
795 Randy
Rascal
Gonzalez
Jackson
Cruz
ADDRESS
CITY
STATE POSTAL CELL PHONE COMMISSION RATE
42 Mountain Ln Cody
WY
82414
307-824-1245 $12,743.16 0.04
87 Pikes Dr
Ralston
WY
82440
307-406-4321
$20,872.11 0.06
312 Oak Rd
WY
82440
$14,912.92 0,04
Powell
Elk Butte WY
19 Lookout Dr
82433
$0,00
0,04
Smith
ADDRESS
17 Fourth St
21 Simple Cir
53 Verde In
14 Rock La
1 Rascal
Farm Rd
42 Blackwater
Way
16 Rockway
Rd
Hendricks 27 Locklear
Ln
199 18th Ave
22 Jackson
Farm Rd
CITY
Blacksmith 75 Stream Rd
STATE POSTAL EMAIL
Cody WY 82414
Garland WY 82435
Powell WY 82440
Ralston
WY 82440
Cody WY 82414
Elk Butte WY
Wapiti WY
Garland WY
82433
123 Sheepland Elk Butte WY
Rd
Cody WY
82450
82435
Powell WY 82440
Ralston WY 82440
82433
82414
.com
jsmith17@example $80.68
billyruff@example $13.13
spinch2@example $156.38
ssmith5@example $58.60
trascal3@example $17.25
$252.25
.com
.com
.com
.com
mjackson5@
example.com
jgonzo@example
.com
307-982-8401
307-883-9481
ejackson@
example.com
ahendricks7@
example.com
scruz5@example
.com
.com
BALANCE
rblacksmith6@
example.com
$45.20
CREDIT REP
LIMIT ID
$500.00 05
$315.00
$750.00 10
$500.00 15
$500.00 10
$250.00 15
$230.40 $1,000.00 15
$250.00 05
$8.33
Ismith12@example $166.65 $1,000.00 10
$500.00 10
$750.00 05
$500.00 15
$61.50 $500.0005
Transcribed Image Text:Answer each of the following questions using the KimTay Pet Supplies data shown in Figure 2-1. SALES REP REP_ID FIRST NAME LAST NAME Garcia Miller Smith Jackson 05 10 15 20 CUSTOMER CUST_FIRST_ LAST NAME Smith ID 125 182 227 294 314 435 492 543 Susan Richard Donna Daniel 616 721 NAME Joey Billy Sandra 375 Melanie Jackson Tom Samantha Smith James Elmer Angle Sally Rufton Leslie Pincher 795 Randy Rascal Gonzalez Jackson Cruz ADDRESS CITY STATE POSTAL CELL PHONE COMMISSION RATE 42 Mountain Ln Cody WY 82414 307-824-1245 $12,743.16 0.04 87 Pikes Dr Ralston WY 82440 307-406-4321 $20,872.11 0.06 312 Oak Rd WY 82440 $14,912.92 0,04 Powell Elk Butte WY 19 Lookout Dr 82433 $0,00 0,04 Smith ADDRESS 17 Fourth St 21 Simple Cir 53 Verde In 14 Rock La 1 Rascal Farm Rd 42 Blackwater Way 16 Rockway Rd Hendricks 27 Locklear Ln 199 18th Ave 22 Jackson Farm Rd CITY Blacksmith 75 Stream Rd STATE POSTAL EMAIL Cody WY 82414 Garland WY 82435 Powell WY 82440 Ralston WY 82440 Cody WY 82414 Elk Butte WY Wapiti WY Garland WY 82433 123 Sheepland Elk Butte WY Rd Cody WY 82450 82435 Powell WY 82440 Ralston WY 82440 82433 82414 .com jsmith17@example $80.68 billyruff@example $13.13 spinch2@example $156.38 ssmith5@example $58.60 trascal3@example $17.25 $252.25 .com .com .com .com mjackson5@ example.com jgonzo@example .com 307-982-8401 307-883-9481 ejackson@ example.com ahendricks7@ example.com scruz5@example .com .com BALANCE rblacksmith6@ example.com $45.20 CREDIT REP LIMIT ID $500.00 05 $315.00 $750.00 10 $500.00 15 $500.00 10 $250.00 15 $230.40 $1,000.00 15 $250.00 05 $8.33 Ismith12@example $166.65 $1,000.00 10 $500.00 10 $750.00 05 $500.00 15 $61.50 $500.0005
INVOICES
INVOICE_NUM INVOICE_DATE CUST_ID
11/15/2021 125
11/15/2021
227
11/16/2021 294
11/16/2021
182
11/18/2021 435
11/18/2021
125
11/18/2021
435
11/19/2021 616
14216
14219
14222
14224
14228
14231
14233
14237
ITEM
ITEM_ID DESCRIPTION
AD72 Dog Feeding Station
BC33
CA75
DT12
FM23
FS39
FS42
Feathers Bird Cage (12x24x18)
Enclosed Cat Litter Station
Dog Toy Gift 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
Small Pet Carrier
INVOICE_LINE
INVOICE_NUM ITEM_ID QUANTITY QUOTED_PRICE
CA75
AD72
DT12
LD14
Underground Fence System
14216
14219
14219
14222
14224
14228
14228
14231
14233
14233
14233
14237
ON_HAND
12
10
15
27
41
12
5
24
14
23
5
32
KH81
FS42
PF19
UF39
KH81
QB92
WB49
LP73
18
7
34
CATEGORY
DOG
BRD
CAT
DOG
HOR
HOR
FSH
BRD
DOG
DOG
FSH
HOR
CAT
DOG
HOR
B
B
С
B
C
C
A
C
A
B
A
3
2
4
C
B
1
KH81
LD14
LP73
PF19
QB92
SP91
UF39
WB49 Insulated Water Bucket
FIGURE 2-1 Sample data for Kim Tay Pet Supplies (Continued)
A
C
4
1
LOCATION
1
2
1
4
4
3
$37.99
$79.99
$39.99
$47.99
$18.99
$124.99
$74.99
$189.99
$19.99
$109.95
$74.95
$54.95
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
Transcribed Image Text:INVOICES INVOICE_NUM INVOICE_DATE CUST_ID 11/15/2021 125 11/15/2021 227 11/16/2021 294 11/16/2021 182 11/18/2021 435 11/18/2021 125 11/18/2021 435 11/19/2021 616 14216 14219 14222 14224 14228 14231 14233 14237 ITEM ITEM_ID DESCRIPTION AD72 Dog Feeding Station BC33 CA75 DT12 FM23 FS39 FS42 Feathers Bird Cage (12x24x18) Enclosed Cat Litter Station Dog Toy Gift 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 Small Pet Carrier INVOICE_LINE INVOICE_NUM ITEM_ID QUANTITY QUOTED_PRICE CA75 AD72 DT12 LD14 Underground Fence System 14216 14219 14219 14222 14224 14228 14228 14231 14233 14233 14233 14237 ON_HAND 12 10 15 27 41 12 5 24 14 23 5 32 KH81 FS42 PF19 UF39 KH81 QB92 WB49 LP73 18 7 34 CATEGORY DOG BRD CAT DOG HOR HOR FSH BRD DOG DOG FSH HOR CAT DOG HOR B B С B C C A C A B A 3 2 4 C B 1 KH81 LD14 LP73 PF19 QB92 SP91 UF39 WB49 Insulated Water Bucket FIGURE 2-1 Sample data for Kim Tay Pet Supplies (Continued) A C 4 1 LOCATION 1 2 1 4 4 3 $37.99 $79.99 $39.99 $47.99 $18.99 $124.99 $74.99 $189.99 $19.99 $109.95 $74.95 $54.95 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
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 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
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education