Database Processing by Kroenke 14th edition

CH 10C H

Create a table named ALLOWED_NATIONALITY with one column called Nation. Place the values of all nationalities currently in the View Ridge database into the table. If possible, write a trigger that will check to determine whether a new or updated value of Nationality resides in this table, and, if not, write an error message and roll back the insert or change. Use the MySQL Workbench to demonstrate that your trigger works. If it is not possible to write a MySQL trigger, explain why and write an equivalent stored procedure.