Database Processing (14th Edition) chapter 10c SQL/PSM Assignment Answer the following questions on pages 10C-106 to 10C-107: 10C.36 F.

Q-1) Procedure to add a new artist. Write a stored procedure to add a new artist into the ARTIST table. Research data for two actual artists, and add those data to the ARTIST table using your stored procedure in the MySQL Workbench. 10C.36 H. Procedure to update customer phone.

Q-2) Write a stored procedure to update customer phone data. Assume that your stored procedure receives LastName, FirstName, PriorAreaCode, NewAreaCode, PriorPhoneNumber, and NewPhoneNumber. Your procedure should first ensure that there is only one customer with the values of (LastName, FirstName, PriorAreaCode, PriorPhoneNumber). If not, produce an error Message and quit. Otherwise, update the customer data with the new phone number data, and print a results message.

Q-3) 10C.36 I. Procedure to add a new artist while checking whether his/her nationality is valid. 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. write a stored procedure 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 Stored procedure works.