Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
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)
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...
See similar textbooks
icon
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.

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
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 3 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
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 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)
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
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS