Procedure $(20pts$

Implement a conditional CASE $--$ raising salary of Staff

$(1)$ Start phpMyAdmin and choose dreamhome database

$(2)$ Click on Routines tab and add routine

$(3)$ Select procedure and give name raiseSalary

$(4)$ Drop input output parameter $($this case, no parameter$)$

$(5)$ Enter code

UPDATE Staff

SET salary $=$ CASE

WHEN oPosition $=$ 'Manager'

THEN salary $*1\mathrm{.}05$

ELSE

salary $*1\mathrm{.}02$

END;