$1)$ Consider the following trigger that will execute when the manager of the department is updated. Add the necessary code to raise salary of the new manager by $5\%$: $(4$ points$)$

CREATE OR REPLACE TRIGGER trg$\_$dept

BEFORE UPDATE OF Mgr$\_$ssn ON DEPARTMENT

FOR EACH ROW

BEGIN

END;

You may test it like this by making:

UPDATE DEPARTMENT SET Mgr$\_$ssn$=666884444$ WHERE Dnumber$=5$;

Now check the salary of the employee whose SSN$=666884444$ and verify that it is $39900.$

$2)$ Complete the following stored procedure list$\_$dependents on page $2.$ This procedure has one input parameter called emp$\_$ssn and when called, will produce a report showing the dependents $($if any$)$ of this employee. Here is an example to illustrate this procedure: $(6$ points$)$

SQL$>$ exec list$\_$dependents$(123456789)$;

Dependent$\_$name Relationship

$=====================================$

Michael Son

Alice Daughter

Elizabeth Spouse

create or replace procedure list$\_$dependents$($emp$\_$ssn IN char$)$ IS

cursor dependents$\_$cursor is

begin

dbms$\_$output.put$\_$line$(\text{'}$Dependent Name Relationship'$)$;

dbms$\_$output.put$\_$line$(\text{'}==================================\text{'})$;

open dependents$\_$cursor;

loop

end loop;

close dependents$\_$cursor;

end;