Question: I need some help with this question. below are the tables and the Line table. I need this in SQL, not ORACLE. 6. Assume customer
I need some help with this question. below are the tables and the Line table. I need this in SQL, not ORACLE.

6. Assume customer 10014 returns all his/her purchases to the store. a. Create a trigger for delete on invoice table that will update OrderStatus column of line table to 'Returned' and load the customer number in CUST NUMBER, if the purchase date is within the last 18 months. [5] CUSTOMER CUST LNAME CUST FNAME CUSTINITIAL CUST AREACODE CUST PHONE CUST BALANCE CUST NUMBER 0014 222-1672 0015 O'Bnan LINE Y NUMBER V INV NUMBER LINE NUMEER CUST NUMBER INV DATE PROD CODE INV. SUBTOTAL LINE UNITS INV TAX LINE PRICE INV TOTAL LINE AMOUNT PROD CODE CUSTOMER INV PAY TYPE PROD DESCRIPT V CUST NUMBER INV PAY AMOUNT PROD INDATE CUST LNAME INV BALANCE PROD.QOH CUST FNAME PROD MINI CUST INITIAL PROD PRICE CUST AREACODE PROD DISCOUNT CUST PHONE VENDOR VEND NUMBER ACCT TRANSACTION CUST BALANCE YVEND NUMBER ACCT TRANS NUM VEND NAME ACCT TRANS DATE VEND CONTACT CUST NUMBER ACCT TRANS, MPE VEND PHONE ACCT TRANS AMOUNT VEND STATE VEND ORDER LINE NUMBER LINE NUMBER PROD CODE LINE UNITS LINE PRICE LINE AMOUNT NN 4243213 69.99 69.99 003 4243213 39 0637032 69.99 200247 69.99
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
