INVOICE LINE CUSTOMER 1 OO CUS CODE CUS LNAME CUS FNAME CUS_INITIAL CUS AREACODE CUS PHONE CUS CREDITLIMIT CUS BALANCE CUS DATELSTPMT CUS DATELSTPUR INV NUMBER CUS CODE INV DATE INV TOTAL INV TERMS INV STATUS INVNUMBER LINE NUMBER P.CODE LINE UNITS LINE PRICE PRODUCT - P.CODE P. DESCRIPT PINDATE P MIN P PRICE P DISCOUNT V CODE PAYMENTS VENDOR V.CODE V NAME V.CONTACT V AREACODE V.PHONE V STATE V.ORDER PMT ID PMT DATE CUS CODE PMT AMT PMT TYPE PMT DETAILS 1. Using this database, write the SQL code to represent the following transaction. Use BEGIN TRANSACTION and COMMIT to group the SQL statements in logical transactions. On March 28, 2016, customer '80200' makes a credit purchase (30 days) of one unit of product 1546-QQ2' with a unit price of S30.00; the tax rate is 8 percent. The invoice number is 9910, and this invoice has only one product line 2. Create a simple transaction log, in the table below, to represent the actions of the previous transaction in #7. AFTER VALUE TRL TRX PREV NEXT ROW ID BEFORE ID NUM PTR PTR OPERATION TABLE ATTRIBUTE VALUE 3. Assuming that pessimistic locking is being used, but the two-phase locking protocol is not, create a chronological list of the locking, unlocking, and data manipulation activities that would occur during the complete processing of the transaction described in Problem 7. Time Action Assuming that pessimistic locking with the two-phase locking protocol is being used, create a chronological list of the locking, unlocking, and data manipulation activities that would occur during the complete processing of the transaction described in Problem 7. 4. TimeAction