Answered step by step
Verified Expert Solution
Link Copied!

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

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

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Statistics For Business And Economics

Authors: James T. McClave, P. George Benson, Terry T Sincich

12th Edition

032182623X, 978-0134189888, 134189884, 978-0321826237

More Books

Students also viewed these Databases questions