Database Admin mysql:

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

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

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

You can use this model to give you a clear idea:

IGURE P10.6 THE ABC MARKETS RELATIONAL DIAGRAM INVOICE LINE 7 IN -NUMBER .. 1 00 7 INV NUMBER LINE_NUMBER CUS CODE CUS LNAME CUS FNAME CUS INIMAL CUS AREACODE CUS PHONE CUS CREDITLIMIT CUS BALANCE CUS DATELSTPMT CUS DATELSTPUR PRODUCT CUS CODE INV DATE INV TOTAL INV TERMS INV STATUS P.CODE P DESCRIP P INDATE PQTYOH P CODE LINE UNITS LINE PRICE P MIN P PRICE P.DISCOUNT VCODE VENDOR PAYMENTS V NAME V CONTACT V AREACODE V PHONE V STATE V ORDER PMT DATE cus.coDE PMT AMT PMT TYPE PMT DETAILS IGURE P10.6 THE ABC MARKETS RELATIONAL DIAGRAM INVOICE LINE 7 IN -NUMBER .. 1 00 7 INV NUMBER LINE_NUMBER CUS CODE CUS LNAME CUS FNAME CUS INIMAL CUS AREACODE CUS PHONE CUS CREDITLIMIT CUS BALANCE CUS DATELSTPMT CUS DATELSTPUR PRODUCT CUS CODE INV DATE INV TOTAL INV TERMS INV STATUS P.CODE P DESCRIP P INDATE PQTYOH P CODE LINE UNITS LINE PRICE P MIN P PRICE P.DISCOUNT VCODE VENDOR PAYMENTS V NAME V CONTACT V AREACODE V PHONE V STATE V ORDER PMT DATE cus.coDE PMT AMT PMT TYPE PMT DETAILS