Database System Concepts
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
Bartleby Related Questions Icon

Related questions

Question

Task 12: When deleting a customer, subtract the balance multiplied by the sales rep’s commission rate from the commission for the corresponding sales rep.

REP_ID
FIRST_NAME
LAST_NAME
ADDRESS
CITY
STATE
POSTAL
CELL_PHONE
COMMISSION
RATE
05
Susan
Garcia
42 Mountain Ln
Cody
WY
82414
307-824-1245
12743.16
0.04
10
Richard
Miller
87 Pikes Dr
Ralston
WY
82440
307-406-4321
20872.11
0.06
15
Donna
Smith
312 Oak Rd
Powell
WY
82440
307-982-8401
14912.92
0.04
20
Daniel
Jackson
19 Lookout Dr
Elk Butte
WY
82433
307-883-9481
0.00
0.04
expand button
Transcribed Image Text:REP_ID FIRST_NAME LAST_NAME ADDRESS CITY STATE POSTAL CELL_PHONE COMMISSION RATE 05 Susan Garcia 42 Mountain Ln Cody WY 82414 307-824-1245 12743.16 0.04 10 Richard Miller 87 Pikes Dr Ralston WY 82440 307-406-4321 20872.11 0.06 15 Donna Smith 312 Oak Rd Powell WY 82440 307-982-8401 14912.92 0.04 20 Daniel Jackson 19 Lookout Dr Elk Butte WY 82433 307-883-9481 0.00 0.04
CUST ID
FIRST NAME
LAST_NAME
ADDRESS
CITY
STATE
POSTAL
EMAIL
BALANCE
CREDIT_LIMIT
REP_ID
125
Joey
Smith
17 Fourth St
Cody
WY
82414
jsmith17@example.com
80.68
500.00
05
182
Billy
Rufton
21 Simple Cir
Garland
WY
82435
billyruff@example.com
43.13
750.00
10
227
Sandra
Pincher
53 Verde Ln
Powell
WY
82440
spinch2@example.com
156.38
500.00
15
294
Samantha
Smith
14 Rock Ln
Ralston
WY
82440
ssmith5@example.com
58.60
500.00
10
314
Tom
Rascal
1 Rascal Farm Rd
Cody
WY
82414
trascal3@example.com
17.25
250.00
15
375
Melanie
Jackson
42 Blackwater Way
Elk Butte
WY
82433
mjackson5@example.com
252.25
250.00
05
435
James
Gonzalez
16 Rockway Rd
Wapiti
WY
82450
jgonzo@example.com
230,40
1000.00
15
492
Elmer
Jackson
22 Jackson Farm Rd
Garland
WY
82435
ejackson4@example.com
45.20
500.00
10
543
Angie
Hendricks
27 Locklear Ln
Powell
WY
82440
ahendricks7@example.com
315.00
750.00
05
616
Sally
Cruz
199 18th Ave
Ralston
WY
82440
scruz5@example.com
8.33
500.00
15
721
Leslie
Smith
123 Sheepland Rd
Elk Butte
WY
82433
Ismith12@example.com
166.65
1000.00
10
795
Randy
Blacksmith
75 Stream Rd
Cody
WY
82414
rblacksmith6@example.com
61.50
500.00
05
expand button
Transcribed Image Text:CUST ID FIRST NAME LAST_NAME ADDRESS CITY STATE POSTAL EMAIL BALANCE CREDIT_LIMIT REP_ID 125 Joey Smith 17 Fourth St Cody WY 82414 jsmith17@example.com 80.68 500.00 05 182 Billy Rufton 21 Simple Cir Garland WY 82435 billyruff@example.com 43.13 750.00 10 227 Sandra Pincher 53 Verde Ln Powell WY 82440 spinch2@example.com 156.38 500.00 15 294 Samantha Smith 14 Rock Ln Ralston WY 82440 ssmith5@example.com 58.60 500.00 10 314 Tom Rascal 1 Rascal Farm Rd Cody WY 82414 trascal3@example.com 17.25 250.00 15 375 Melanie Jackson 42 Blackwater Way Elk Butte WY 82433 mjackson5@example.com 252.25 250.00 05 435 James Gonzalez 16 Rockway Rd Wapiti WY 82450 jgonzo@example.com 230,40 1000.00 15 492 Elmer Jackson 22 Jackson Farm Rd Garland WY 82435 ejackson4@example.com 45.20 500.00 10 543 Angie Hendricks 27 Locklear Ln Powell WY 82440 ahendricks7@example.com 315.00 750.00 05 616 Sally Cruz 199 18th Ave Ralston WY 82440 scruz5@example.com 8.33 500.00 15 721 Leslie Smith 123 Sheepland Rd Elk Butte WY 82433 Ismith12@example.com 166.65 1000.00 10 795 Randy Blacksmith 75 Stream Rd Cody WY 82414 rblacksmith6@example.com 61.50 500.00 05
Expert Solution
Check Mark
Knowledge Booster
Background pattern image
Computer Science
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
Text book image
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education