Write a script that creates and calls a stored procedure named $"$cs$431\_$question$3".$ This

procedure should include a set of two SQL statements coded as a transaction to delete the row

with an invoice id of $12$ from the Invoices table. To do this, you must first delete all the line

items for that invoice from the invoice$\_$line$\_$items table.

If these statements execute successfully, commit the changes. Otherwise, roll back the changes.

Expected output of invoice table and invoice$\_$line$\_$items:

IF execution of transaction is Successful then no rows should exists with invoice$\_$id $12$ in both

tables.

If not successful, there exists rows with invoice$\_$id $12$ in both tables

Use AP database and invoices table and invoice$\_$line$\_$items for this query.