Import sales$\_$tax$\_$rate.sql and sales$\_$tax$\_$rate.txt $[$from week$-1]$ to create the tables and data in your database.

$2.$

Write a procedure $($name the procedure as tax$\_$increase$\_$yourFirstName$)$ to increase the sales tax to a certain percentage, and the states' names started with the letter A$.$ Please find the last digit of your student number; if it is $2,$ increase the tax rate by $2\%.$ If the last digit is $9$ for another student, then increase tax by $9\%$ and so on$.$

$4$

$3.$

After completing the coding task, export the code for submission.

$4$

Add your name and student number at the top of the code file as a comment.

Put necessary comments to explain your code inside the $.$sql file.

$1$

Part$-2$

No

Task

Mark$($s$)/5$

$1.$

Import Canadian$\_$pt$.$sql file to create the table in the database you created

$2.$

Write a trigger $($name the trigger as capt$\_$yourFirstName$)$ to ensure the upper case of the provincial or territorial iso code$/$shortcode$.$ Another way is if someone gives input ON as on$,$ the trigger will turn the input to ON$.$ Try the following values to ensure the trigger is working

$(4,$'New Brunswick',$\text{'}$nb$\text{'}),$

$(5,$'Manitoba',$\text{'}$mb$\text{'}),$

$(6,$'British Columbia',$\text{'}$bc$\text{'}),$

$(7,$'Prince Edward Island',$\text{'}$pe$\text{'}),$

$4$

$3.$

After completing the coding task, export the code for submission.

$4$

Add your name and student number at the top of the code file as a comment.

Put necessary comments to explain your code inside the $.$sql file.