Why my code cannot run? FIGURE P8.31 CH08_SALECO2 DATABASE TABLESDatabase name: Ch08_SaleCo2Table name: CUSTOMERTable name: INVOICECUS CooE CuS LNAMECUS PNAME CuS NMAL CUSAREACOCE CU PHONE CuS BALANCEOIE RumasCO1 DureW NUNGER | CUS_CO DATE100 19014 16--11001 16Jan-18TOTAL TA otALAhetLreKay54404-126000107019012 16n-t10011 17an-1810018153S0013 ObenkiKCO14 Odundo MyrenCOS O56 76000.00221 19164-210222-14032-121004100s2807044JamesGege100010014 17an-1810017 wane1510015 1tlan1820000 Fart210000AreClate1001 t1008431 de615207-00Table name: LINEWNUMEES DENUMBERCOCE| LHE UNTS UE PRICE UHE TOTALTable name: PRODUCT149914910011DERO Power pairte, 15 pa, Seorz13-02 per bde140 900 p e001000499130eo-1714010001.223/OPD13Nv-1715a1a121749000 2134410003 1302274914 9019.0070.44207108 921000149019 om H 10n,0z Y DO gnew. 12n15-n-1234319920e-1724ec11004100622OHE1 PVCZDRT1 SM 10772 22OTY9.06ar1222ORD BIO conder I020He O hanmer21LAA Seanner, 1254778-2 R tie, 1 eWEO Heu chan saw, 10.PVCDRT PVC pn, 3Sin, 620-n-1812100610 21251006100610061000100720--182310995109 9014 40150ec-172000 21441 13COP29 9849929352.149020S 24001 PVCCAT2 WRSTT49068119 61006S18277 125n eow, 25SN2E 25A wd. sorew.eARSTS Seeiming, t, nesh1275000 21225000 2120110 2510061000100Table name: VENDORVCOE VNAME VCONTACT VAREACODEV PHONE V STATE VORDER2125 y, e2126 upeles, he.21201 DE Seply21344 Gome B22T Dome Saphy23119 Randets u24004 Brackenan Bros20 ORDVA, n44 DAK, he.20 Darl Suple2S Rico Syster DSrathenPushingSinghDeega22-3 TN215-6 FL616616TMSathGAAnderBrning101615206-1410124TNBrh10422000FLBreytheTNPL31. Create a trigger named trg_line_total to write the LINE_TOTAL value in the LINEtable every time you add a new LINE row. (The LINE_TOTAL value is the productof the LINE_UNITS and LINE_PRICE values.) D Server: 127.0.0.1 » O Database: cho8 saleco »Table: lineBrowseA StructureU SQLSearchi InsertA ExportImportI PrivilegesOperationsO Tracking% TriggersRun SQL query/queries on table ch08_saleco.line: eColumns1 CREATE OR REPLACE TRIGGER TRG_LINE_TOTALINV NUMBERLINE_NUMBERP CODELINE UNITSLINE_PRICE2 BEFORE INSERT ON line3 FOR EACH ROW4 BEGIN5 :NEW.LINE_TOTAL :=:NEW.LINE_UNITS*:NEW.LINE_PRICE;6 END;SELECT *SELECTINSERTUPDATEDELETEClearFormatGet auto-saved queryO Bind parameters e<<Bookmark this SQL query:V Show this query here again O Retain query box O Rollback when finished V Enable foreign key checks[ DelimiterErrorSQL query: Copy.CREATE OR REPLACE TRIGGER TRG_LINE_TOTALBEFORE INSERT ON lineFOR EACH ROWBEGIN: NEW. LINE_TOTAL :=:NEW.LINE_UNITS*:NEW.LINE_PRICEMYSQL said: e#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ':NEW.LINE_TOTAL :=:NEW.LINE_UNITS*:NEW.LINE_PRICE' at line 5

OBJECTIVE: Here a trigger would be written to insert the values for the column LINE_TOTAL that would…

FIGURE P8.31 CH08_SALECO2 DATABASE TABLES Database name: Ch08_SaleCo2 Table name: CUSTOMER Dcoor CUUNAME CUAME CUSAL AEACOce cuPHOE CUALANCE| Table name: INVOICE TO 16- 1 16 FO 2 1 1004 1011 17n 10 1 17 100 1014 17 10 15 KON Ound Mm s O Ay 222 000 212 Table name: LINE Table name: PRODUCT 2 2O TER Pwr part, 15Seorze 13 p 14g pc R 038 -17 13-17 13--17 2 15 15 2 S 9 2 2a DO ,n 22e , 22 O coe IG 2 O haner 200-17 12 20 20 12 23 10 2 2oty 10 996 1440 54778-2 e 1006 S77 1 ,2 2 2 1 45 Ih 11 2 wRm 329CHE 1000 Sing, ve, Peh Table name: VENDOR V coe VNAE [VCONTACT |VECOVOEV TATE VE 2 L Png Dee Sth Arder 2 D 2 Geme 2 D Shy 231 Ran ue 200 an OROVA 240 , Deete GA 01 N Bthe Sytew Den 31. Create a trigger named trg_line_total to write the LINE_TOTAL value in the LINI table every time you add a new LINE row. (The LINE_TOTAL value is the produc of the LINE_UNITS and LINE_PRICE values.)

FIGURE P8.31 CH08_SALECO2 DATABASE TABLES Database name: Ch08_SaleCo2 Table name: CUSTOMER Dcoor CUUNAME CUAME CUSAL AEACOce cuPHOE CUALANCE| Table name: INVOICE TO 16- 1 16 FO 2 1 1004 1011 17n 10 1 17 100 1014 17 10 15 KON Ound Mm s O Ay 222 000 212 Table name: LINE Table name: PRODUCT 2 2O TER Pwr part, 15Seorze 13 p 14g pc R 038 -17 13-17 13--17 2 15 15 2 S 9 2 2a DO ,n 22e , 22 O coe IG 2 O haner 200-17 12 20 20 12 23 10 2 2oty 10 996 1440 54778-2 e 1006 S77 1 ,2 2 2 1 45 Ih 11 2 wRm 329CHE 1000 Sing, ve, Peh Table name: VENDOR V coe VNAE [VCONTACT |VECOVOEV TATE VE 2 L Png Dee Sth Arder 2 D 2 Geme 2 D Shy 231 Ran ue 200 an OROVA 240 , Deete GA 01 N Bthe Sytew Den 31. Create a trigger named trg_line_total to write the LINE_TOTAL value in the LINI table every time you add a new LINE row. (The LINE_TOTAL value is the produc of the LINE_UNITS and LINE_PRICE values.)

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

See similar textbooks

Similar questions

An infinite loop is an instruction sequence in Java that loops endlessly when a functional exit isn't met. True False
How do you execute instructions stored in location127H or 178H? explain please
Should the CPU and memory be connected through an asynchronous or synchronous interface? Do you need to provide a justification?
NASM, x86-64 instructions and architecture, Loops, System calls, ASCII Can someone please help me write a NASM assembly language program "caesar.asm" that does caesar cipher involves shifting letters in the given string by a given number in the alphabet? Thank you very much for your help. The program should: Ask for user input between -20 and 20 Ask the user for a string and display the unedited string that the user entered Lastly, display the caesar cipher edited string.
Why is NonActionAttribute so important?
I've been working on this project about an assembly-language program that prints the binary version of a four numeral decimal number (such as 3241) to the console, I finished the code but when I run it into LC-3 simulator I get his error "Oh no! You've got an error in your assembly code: at line 16: immediate field is out of range: expected value to fit in 5 bits (i.e., to be between -16 and 15, inclusive), but found 48" I tried to changed the numbers but it didn't work I just need help solving this error so it's able to run into the simulator and prints the output into the console here is the link of the simulator I'm using and my code: link: https://wchargin.com/lc3web/ Code: ;Kevin Hernandez;assembly3.asm A) BINARY TO ASCII;Lavels OPCODE OPERANDS ;Line up the columns .ORIG x3000;data sectionNUMBER .FILL #3241 ;This number is store in NUMBERBIN_REP .BLKW #16 ;This is 16-bit ;code section…
Siemens programming uses the letter 'Q' to indicate an output address. What letter does the Allen Bradley software use? (Just the letter for an answer)
Do you know how instruction cycles operate in practice?
Create a loop using the pattern via Python
In order to correct errors, what factors must be considered? What do the lines that seem like debugging instructions really mean?
Explain what it means to work as a "Assembler."
What exactly is "clocking," and why do you need to configure it?