Create a stored procedure named prc_inv_amounts to update the INV_SUBTOTAL, INV_TAX, and INV_TOTAL. The procedure takes the invoice number as a parameter. The INV_SUBTOTAL is the sum of the LINE_TOTAL amounts for the invoice, the INV_TAX is the product of the INV_SUBTOTAL and the tax rate (8 percent), and the INV_TOTAL is the sum of the INV_SUBTOTAL and the INV_TAX.
Create a stored procedure named prc_inv_amounts to update the INV_SUBTOTAL, INV_TAX, and INV_TOTAL. The procedure takes the invoice number as a parameter. The INV_SUBTOTAL is the sum of the LINE_TOTAL amounts for the invoice, the INV_TAX is the product of the INV_SUBTOTAL and the tax rate (8 percent), and the INV_TOTAL is the sum of the INV_SUBTOTAL and the INV_TAX.
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Related questions
Question
Do this in MySQL please:
Create a stored procedure named prc_inv_amounts to update the INV_SUBTOTAL, INV_TAX, and INV_TOTAL. The procedure takes the invoice number as a parameter. The INV_SUBTOTAL is the sum of the LINE_TOTAL amounts for the invoice, the INV_TAX is the product of the INV_SUBTOTAL and the tax rate (8 percent), and the INV_TOTAL is the sum of the INV_SUBTOTAL and the INV_TAX.
Transcribed Image Text:FIGURE P8.31
CH08_SALECO2 DATABASE TABLES
Database name: Ch08_SaleCo2
Table name: CUSTOMER
Table name: INVOICE
CUS_CODE CUS_LNAME CUS_FNAME CUS_INITIAL CUS_AREACODE CUS_PHONE CUS_BALANCE
10010 Ramas
10011 Dunne
INV_NUMBER CUS_CODE INV_DATE INV_SUBTOTAL INV_TAX INV_TOTAL
Alfred
044-2573
A
K
615
713
0 00
0.00
1001
10014
16-Jan-18
24.90
1.99
26.89
Leona
894-1238
1002
10011
16-Jan-18
9.98
0.80
10.78
10012 Smith
Kathy
515
894-2285
345.86
1003
10012
16-Jan-18
153.85
12.31
166.16
10013 Olowski
Paul
F
615
894-2180
536.75
1004
10011
17-Jan-18
34.97
2.80
37.77
Myron
Amy
10014 Orlando
615
222-1672
0.00
10015 O'Brian
442-3381
1005
10018
17-Jan-18
70.44
5.64
76.08
B
713
0.00
10016 Brown
James
615
297-1228
221. 19
1006
10014
17-Jan-18
397.83
31.83
429.66
10017 Williams
10018 Farrice
George
Anno
615
713
290-2556
382-7186
760.93
216.55
0.00
1007
10015 17-Jan-18
34.97
2.80
37.77
G
1008
10011 17-Jan-18
399.15
31.93
431.08
10019 Smith
Olette
K
615
297-3809
Table name: LINE
Table name: PRODUCT
INV_NUMBER| LINE_NUMBER| P_CODE | LINE_UNITS
1 13-Q2/P2
2 23103 HE
1 54778-2T
|
LINE PRICE
LINE TOTAL
P_CODE
P_INDATE P_QOH P_MIN P_PRICE P_DISCOUNT V_CODE
1001
1001
14.99
9.96
14.99
9.95
P_DESCRIPT
1
03-Nov-17
11QER/31 Power painter, 15 psi., 3-nozzle
13-02P2 7.25-in. pwr. saw blade
14-Q1L3 9.00-in. pwr. saw blade
8
109.99
0.00
25595
1002
4.99
9.98
13-Dec-17
32
15
14.99
0.05
21344
1003
1 2238/OPD
1
38.95
38.95
13-Nov-17
18
12
17.49
0.00
21344
2 1546-002
3 13-02/P2
1 54773-2T
1003
39.95
39.95
1546-QQ2 Hrd. cloth, 1/4-in., 2x50
1558-QW1 Hrd. cloth, 1/2-in., 3x50
2232/QTY B&D jigsaw, 12-in. blade
2232/GVE B&D jigsaw, 8-in. blade
2238/QPD B&D cordless drill, 1/2-in.
15-Jan-18
15
8.
39.95
0.00
23119
1003
14.99
74.95
15-Jan-18
23
5
43.99
0.00
23119
1004
1004
3
4.99
14.97
19 90
70.44
30-Dec-17
8
109.92
0.05
24288
2 23109-HE
2
9.95
TO04
24288
25595
99.87
0.05
1 PVC23DRT
1 SM-18277
24-Dec-17
1005
12
5.67
20-Jan-18
12
38.95
0.05
1005
1006
1005
3
6.99
20.97
23109-HB Claw hammer
20-Jan-18
23
10
9.95
0.10
21225
2 2232/QTY
1
1.
109.92
109.92
3 23109-HE
9 95
9.95
256.99
1
5
23114-AA Sledge hammer, 12 Ib.
54778-2T Rat-tail file, 1/8-in. fine
02-Jan-18
8
14.40
0.05
15-Dec-17
43
20
4.99
0.00
21344
1006
4 89-WRE-Q
1
256.99
1 13-02/P2
2 54778-2T
1 PVC23DRT
1007
14.59
29.98
89-WRE-Q Hicut chain saw, 16 in.
07-Feb-18
11
256.99
0.05
24288
1007
1
4.99
4. 99
PVC23DRT PVC pipe, 3.5-in., 8-ft
SM-18277 1.25-in. metal screw, 25
SW-23116 2.5-in. wd. screw, 50
20-Feb-18
188
75
5.87
0.00
5.67
119.96
1003
29.35
01-Mar-18
172
75
6.99
0.00
21225
359.86
9 95
1008
2 WR/IT3
3
24-Feb-18
237
100
8.45
21231
0.00
0.10
1008
3 23109-HE
1
VWR3/TT3 Steel matting, 4x8x1/6", 5" mesh
17-Jan-18
18
5
119.95
25595
Table name: VENDOR
V AREACODE V_PHONE V_STATE
V_CODE
21225 Bryson, Inc.
V_NAME
Smithson
615
223-3234
TIN
Flushing
21226 SuperLoo, Inc.
21231 D&E Supply
904
215-8996
FL
228-3245
Singh
Ortega
Smith
615
TN
21344 Gomez Bros.
615
889-2546
KY
N.
901
678-1419
22567 Dome Supply
23119 Randsets Lid.
24004 Brackman Bros.
24288 OROVA, Inc.
25443 B&K, Inc.
Z5501 Damal Supplies
901
GA
N
Anderson
901
678-3998
GA
Y
Browning
Hakford
615
228-1410
TN
N
615
898-1234
TN
Y
Smith
904
227-0093
FL
Smythe
25595 Rubicon Systems Orton
615
890-3529
TN
904
456-0092
FL
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 3 images
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY