Question: Could anyone please help me this question... 6.2 [20] Using the following structure, create a trigger to log jobs or departments changing on employees table.
Could anyone please help me this question...
![Could anyone please help me this question... 6.2 [20] Using the following](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2024/09/66f3db4ec980e_42266f3db4e6af67.jpg)
6.2 [20] Using the following structure, create a trigger to log jobs or departments changing on employees table. When an employee's job or department are changed, the previous job and department id are stored in job history table. The trigger should not be fired if the new job id and department id are remain the same, or if the update statement is on the columns other than job_id or department_id. JOH_HISTORY EMPLOYEES emploid (PK) employee id IPKI jul IPK employee_mame Startdal (PKI Hite_dat und date cb_id pament Start_jeldatu salary department_id
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
