I am using the oracel sql developer so plz answer through the oracel sql developer 6-(10%) Take

I am using the oracel sql developer so plz answer through the oracel sql developer

Transcribed Image Text:

6-(10%) Take the 2 triggers you have previously created and combine them into a single trigger called staff_trig which continues to provide all the functionality of the previous triggers - and - also handles a DELETE by recording (INSERT) a record into the STAFFAUDTBL when a DELETE occurs. Here is the new STAFFAUDTBL schema and how to handle I/U/D: Columns: - ID (ID of the record being affected) ACTION ("1" or "U" or "D" based on what action is happening) INCJOB (The value of a non-valid JOB in the case of an INSERT or UPDATE, otherwise NULL if JOB value is fine - see valid values in Q3) OLDCOMM (The value of old commission if there is ANY change to COMM from an UPDATE, otherwise NULL) - NEWCOMM (The value of new commission if there is ANY change to COMM from an UPDATE, otherwise NULL) Drop the existing STAFFAUDTBL. Create a new STAFFAUDTBL. Make sure you DISABLE your two existing triggers so both don't fire at the same time. Test your new trigger. 6-(10%) Take the 2 triggers you have previously created and combine them into a single trigger called staff_trig which continues to provide all the functionality of the previous triggers - and - also handles a DELETE by recording (INSERT) a record into the STAFFAUDTBL when a DELETE occurs. Here is the new STAFFAUDTBL schema and how to handle I/U/D: Columns: - ID (ID of the record being affected) ACTION ("1" or "U" or "D" based on what action is happening) INCJOB (The value of a non-valid JOB in the case of an INSERT or UPDATE, otherwise NULL if JOB value is fine - see valid values in Q3) OLDCOMM (The value of old commission if there is ANY change to COMM from an UPDATE, otherwise NULL) - NEWCOMM (The value of new commission if there is ANY change to COMM from an UPDATE, otherwise NULL) Drop the existing STAFFAUDTBL. Create a new STAFFAUDTBL. Make sure you DISABLE your two existing triggers so both don't fire at the same time. Test your new trigger.