Database final touches (single page) + extra credit

Extra credit: (triggers and procedures)

Upload your triggers and procedures here, along with the commented SQL statements needed to demonstrate that the triggers and procedures work as advertised.

If they are an integral part of your DB project and cannot be easily extricated, upload a note here that the extra credit work will be found with the project.

"Triggers and procedures submitted for midterm credit must be accompanied by queries (CRUD statements) that demonstrate that they work as advertised, for full credit"

thank you.