Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I am using the oracel sql developer so plz answer through the oracel sql developer 6-(10%) Take the 2 triggers you have previously created and
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started