Section $1.$ Transactions Overview:

Recall that transactions include several SQL statements coded to run in a batch execution $-$ all statements in the batch execute successfully $($commit$),$ or none should be executed $($rollback$).$

For full credit, this section$\text{'}$s deliverable must include:

A$.$ Transaction code $($from BEGIN to COMMIT$)$

B$.$ Screenshots proving that the following Transaction works $-$ before$/$after screenshots.

Statement Requirements:

$1.$ Create a record for a new bill transaction, adding data to Bill and Purchase at the same time. Section $2.$ Triggers$/$Stored Procedures Overview:

Stored Procedures $($also known as "routines"$)$ and Triggers are powerful tools for implementing logic in the database. In your project database, implement the triggers and stored procedures specified below.

For full credit, this section$\text{'}$s deliverable must include:

A$.$ CREATE PROCEDURE and CREATE TRIGGER codes.

B$.$ Screenshots proving that the following procedures and triggers work $-$ before$/$after images.

Use the scripts provided to implement the following statements:

$1.$ TRIGGER: Add a trigger to the bill table so that whenever a new purchase occurs, automatically deduct the quantity from the quantity on hand of that item's inventory in Menu.

$2.$ TRIGGER: Add a trigger to the LoyaltyCustomer table so that whenever the customer purchases a ticket, automatically increment the customer's $\backslash$# of Tickets, and update the Loyalty Level if applicable.

$3.$ PROCEDURE: The loyalty program is based only on tickets purchased in the last year. Create the procedure to update customer $\backslash$# of Tickets that Palermo can run. This should also update the customer's loyalty level if necessary.