Q$5.(15$ points$)$ Trigger based on table Locations. It requires three steps described below.

The first step is to create a log table Log$\_$Location. Similar to the log tables in class notes or assignments, the table should have the necessary columns needed for tracking any changes mentioned below.

The second step: for monitoring the changes of table Locations, you will create a conditional predicates row$-$level trigger called Location$\_$monitor. Whenever there is a command of insert, delete, or update on two special columns of location$\_$id or the city, the trigger will be fired, and a row will be inserted into the table Log$\_$Location with correspondent "action" comments. Your trigger should not be fired when there is change of columns other than the location$\_$id and city. The Log table should record the event date, who is that login name, and the correspondent action.

Step three: after you have successfully built the trigger, you are required to test your trigger using the following commands, and submit the correspondent outputs of the log table.

INSERT INTO LOCATIONS VALUES

$(4000,\text{'}243$ S$.$ Wabash Ave', $\text{'}60604\text{'},$

'Chicago', $\text{'}$IN$\text{'},\text{'}$US$\text{'})$;

UPDATE LOCATIONS

SET city $=$ 'York' WHERE Location$\_$id $=$

$4000$ ;

UPDATE LOCATIONS

SET Street$\_$address $=\text{'}1$ E$.$ Jackson' WHERE

Location$\_$id $=\frac{4}{b}ar(0)00$;

UPDATE LOCATIONS SET Location$\_$id $=4111$ WHERE

Location$\_$id $=4000$;

DELETE LOCATIONS WHERE Location$\_$id $=4111$;

SELECT $*$ FROM Log$\_$Location;

$--$ please submit your output of these

commands.

$--$ ROLLBACK; $--$ cleaning after submitting the

result