(Solved) : Database Processing Kroenke 14th Edition Ch 10c H Create Table Named Allowednationality On Q27939197 . . . .

Database Processing by Kroenke 14th edition

CH 10C H

Create a table named ALLOWED_NATIONALITY with one column calledNation. Place the values of all nationalities currently in the ViewRidge database into the table. If possible, write a trigger thatwill check to determine whether a new or updated value ofNationality resides in this table, and, if not, write an errormessage and roll back the insert or change. Use the MySQL Workbenchto demonstrate that your trigger works. If it is not possible towrite a MySQL trigger, explain why and write an equivalent storedprocedure.

Expert Answer

An answer will be send to you shortly. .