Week $7$ Transaction Management Assignment

Based on the above ERD Diagram of ABC Market 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. Please submit screenshots of your scripts and the output of each table that has been updated.

a$.$ On Jan $22,2024,$ customer $10015$ makes a cash purchase of two units of product $13-$Q$2/$P$2$ with a tag price of $$100\mathrm{.}00$ and a $5\%$ discount rate, and one unit of product $2232/$QTY$$ with a tag price of $$50\mathrm{.}00$ and no discount; the tax rate is $8$ percent. The invoice number is $12434.$ The payment ID is $6595.$

b$.$ On Jan $23,2024,$ customer $10012$ makes a credit purchase of two units of product $23109-$HB$$ with a tag price of $$20$ and a $10\%$ discount. The tax rate is $8$ percent. The pay term is $30$ days. The invoice number is $12456.$

c$.$ On Feb $3,2024,$ customer $10015$ returns one of the products $13-$Q$2/$P$2$ for a full refund. The refund ID $($treat it as a negative payment$)$ is $6890.$

d$.$ On Feb $22,2024,$ customer $10012$ makes the payment toward invoice $12456.$ The payment ID is $6780.$