I am using the oracel sql developer so plz answer through the oracel sql developer 6-(10%) Take
Fantastic news! We've Found the answer you've been seeking!
Question:
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.
Expert Answer:
Related Book For
Statistics For Business And Economics
ISBN: 9780321826237
12th Edition
Authors: James T. McClave, P. George Benson, Terry T Sincich
Posted Date:
Students also viewed these databases questions
-
QUIZ... Let D be a poset and let f : D D be a monotone function. (i) Give the definition of the least pre-fixed point, fix (f), of f. Show that fix (f) is a fixed point of f. [5 marks] (ii) Show that...
-
Represent multisets using binary trees. Compare the representations (a), (b) and (c), stating the advantages and drawbacks of each. [Answers need not contain ML code. You may refer to algorithms and...
-
Titanium metal requires a photon with a minimum energy of 6.94 10 - 19 J to emit electrons. (a) What is the minimum frequency of light necessary to emit electrons from titanium via the photoelectric...
-
In below Problems, use the indicated x-values on the graph of y =f (x) to find the following. 1. Find intervals over which the graph is concave down. 2. Find intervals over which the graph is concave...
-
The stockholders equity accounts of Tender Heart Greeting Cards Inc. for the current fiscal year ended December 31, 2006, are shown on the following page. Prepare a statement of stockholders equity...
-
sounds coming from the north side of her three-story house. Toward the end of the second day, she examined the exterior of her house and noticed two large holes located near the roof. To inspect the...
-
Natalie Koebel spent much of her childhood learning the art of cookie-making from her grandmother. They passed many happy hours mastering every type of cookie imaginable and later creating new...
-
n 1 1. lim tantan is equal to 004-1 1+r+r2 2. 3. If the least and the largest real values of a, for which the equation z + a |2-1+21=0(z=C and i=1) has a solution, are p and q respectively, then 4(p...
-
1. Mr. Albert has a piece of property he has used in his business for 25 years. He is moving his business across the country and needs to get rid of the real estate he currently owns, as he won't be...
-
Evan Corporation provided consulting services for Kensington Company in 2019. Evan incurred costs of $30,000 associated with the consulting and billed Kensington $45,000. Evan paid $20,000 of its...
-
A firm selling a normal good has a price elasticity of demand coefficient of 3.0 and an income elasticity of demand coefficient of 2.2. Assume that economists forecast a recession within the next...
-
Formulate your answer based on the information below. The intensity of care delivered dropped from a budgeted case mix of 0 . 9 0 to an actual case mix of 0 . 8 5 . What dollar effect did this have...
-
What is the difference between a & b? Why? Compare inflation for 1970s and 1980s. Any improvement in the 1990s? What might be one reason for the improvement?
-
Quality Transformation at ABC Manufacturing Company ABC Manufacturing Company, a leading player in the industry, has decided to embark on a quality transformation journey by integrating ISO 9000...
-
Should court fines for offenses (i.e. traffic, quality of life, shoplifting, property damage, etc.) be the same for the poor and the wealthy? Should it be dollar for dollar equal, or should it be a...
-
2. a. What do you mean by sewage treatment? b. Briefly discuss the categories/steps of sewage treatment.
-
Let (X. A. p) be a measure space. Show that for any A,B A, we have the equality: (AUB)+(An B) = (A) + (B).
-
The U.S. Census Bureau reports a decline in the percentage of mothers in the workforce who have infant children. The following table gives a breakdown of the marital status and working status of the...
-
Multiple regression was used to estimate the effect of coaching on SAT-Mathematics scores. Data on 3,492 students (573 of whom were coached) were used to fit the model, E(y) = 0 + 1x1 + 2x2, where y...
-
For a set of data with a mound-shaped relative frequency distribution, what can be said about the percentage of the measurements contained in each of the intervals specified in Exercise 2.72? In...
-
Based on Exhibit 1, the fi nancial leverage ratio for Company B is closest to: A . 0.55. B . 1.22. C . 2.22. EXHIBIT 1 Common-Size Balance Sheets for Company A, Company B, and Sector Average Company...
-
Under which section of a manufacturing companys cash fl ow statement are the following activities reported? Item 1: Purchases of securities held for trading Item 2: Sales of securities considered...
-
Based on Exhibit 1, which ratio indicates lower liquidity risk for Company A compared with Company B? A . Cash ratio. B . Quick ratio. C . Current ratio. EXHIBIT 1 Common-Size Balance Sheets for...
Study smarter with the SolutionInn App