Using this database, write the SQL code to represent each one of the following transactions. Use BEGIN TRANSACTION and COMMIT to group the SQL statements in logical transactions.

On May 11, 2006, customer 10010 makes a credit purchase (30 days) of one unit of product 11QER/31 with a unit price of $110.00; the tax rate is 8%. The invoice number is 10983, and this invoice has only one product line.

On June 3, 2006, customer 10010 makes a payment of $100 in cash. The payment ID is 3428.

Create a simple transaction log (using the same format as that in the case assignment) to represent the actions of the two previous transactions.

INVOICE LINE CUSTOMER aus cODE CUS LNAME CUS FNAME CUS INITIAL CUS AREACODE CUS PHONE CUS CREDITLIMIT CUS BALANCE CUS DATELSTPMT CUS DATELSTPUR INY NMBER CUS CODE INV_DATE INV TOTA INV TERMS INV STATUS INY NMBER PRODUCT P CODE P DESCRIPT P INDATE P QTYOH P MIN PPRICE P DISCOUNT _CODE P CODE LINE_UNITS LINE PRICE VENDOR PAYMENTS PMT D PMT DATE CUS CODE PMT AMT PMT TYPE PMT DETAILS Y CODE V_NAME CONTACT V_AREACODE VPHONE VSTATE V ORDER