Question: Write trigger - varpaychk - which checks for the following compensation rules when a record is INSERTed or UPDATEed into the EMPLOYEE table - BONUS

Write trigger - varpaychk - which checks for the following compensation rules when a record is INSERTed or UPDATEed into the EMPLOYEE table

- BONUS should be < 20% of SALARY

- COMMISSION should be < 25% of SALARY

- Sum of BONUS & COMMISSION should be < 40% of SALARY

Create EMPAUDIT table which records any failure to adhere to the above rules.

The INSERT or UPDATE should still be successful into the EMPLOYEE table, but, an error record should be recorded in the EMPAUDIT table.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Sql Create EMPLOYEE table CREATE TABLE EMPLOYEE EMPID INT PRIMARY KEY SALARY DECIMAL10 2 BONUS DECIM... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

In Prob. 3.55, determine the perpendicular distance between rod AB and the line of action of P. PROBLEM 3.55 The 23-in. vertical rod CD is welded to the midpoint C of the 50-in. rod AB. Determine the...

Q:

The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...

Q:

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Q:

SEE "DOCUMENT 1" FOR CRITERIA 2 "DOCUMENT 2" FOR CRITERIA 4 You are to write a 3 to 4 page paper following APA rules for the title page, citations and appropriate references within the body of the...

Q:

SEE "DOCUMENT 1" FOR CRITERIA 2 "DOCUMENT 2" FOR CRITERIA 4 You are to write a 3 to 4 page paper following APA rules for the title page, citations and appropriate references within the body of the...

Q:

SEE "DOCUMENT 1" FOR CRITERIA 2 "DOCUMENT 2" FOR CRITERIA 4 You are to write a 3 to 4 page paper following APA rules for the title page, citations and appropriate references within the body of the...

Q:

SEE "DOCUMENT 1" FOR CRITERIA 2 "DOCUMENT 2" FOR CRITERIA 4. You are to write a 2 to 4 page paper following APA rules for the title page, citations and appropriate references within the body of the...

Q:

Write trigger - nomgr - which checks for the following when an INSERT, UPDATE or DELETE takes place that ensures every employee has a manager. Create EMPAUDIT table. Start by INSERTing a HR Manager...

Q:

October 9, 20- The first payroll in October covered the two workweeks that ended or September 26 and October 3. This payroll transaction has been entered for you in the payroll register, the...

Q:

and Ryan) are union members. OJECT AUDIT Union Dues Both workers in the plant (Homo and Ryan) are union men check-off system, $s is deducted each payday from the plant for union dues, assessments,...

Q:

What is the principal portion of the 200th payment. A fully amortizing $250,000, 30-year.Fixed rate loan with an interest rate of 4.825 percent? What is the total monthly interest and principal...

Q:

What is the primary requirement for classification of an asset as a current asset?

Q:

Question 1 8 ( 2 . 5 points ) Which o f the following i s a formula t o calculate future value? F V = P V ( 1 + r ) n F V = P V ( 1 + r ) n F V = n r F V = r P V

Q:

Use the step-by-step technique to find V0(t) for t > 0 in the circuit in Fig. P6.47. 12V 12 2H 40 Vo( 2

Q:

Find V0(t) for t > 0 in the circuit in Fig. P6.48 using the step-by-step method. t=0 2 3 SH 6 12V 3 162

Q:

A mixture of 60% helium and 40% nitrogen by mass enters a turbine at 1 MPa, 800 K at a rate of 2 kg/s. The adiabatic turbine has an exit pressure of 100 kPa and an isentropic efficiency of 85%. Find...

Q:

Candy Canes weekly gross earnings for the present week were $1,370. Mellow has one exemption. Using the wage bracket withholding table in Exhibit 2 with a $81 standard withholding allowance for each...

Q:

In one year, the CPI increased from 125.9 to 127.2. How much money was required at the end of the year in order to have the same purchasing power as $1000 at the beginning?

Q:

To instilute a nonputicial forectosure, the trustee or mortgagee may be required fo record a notice ofA) collection foreclosure at the county recorder's office.Fi) forectosure at the state records...

Q:

Why do U.S. multinationals generally like the check-the-box regulations?

Q:

What are the nontax benefits, if any, of a stock acquisition? What are the nontax costs, if any, of a stock acquisition?

Q:

How might tax savings be sacrificed to achieve organizational design efficiencies or to mitigate political costs?

Q:

The X-John Company makes batteries specifically designed for cellular telephones. Recently, the research and development (R&D) department developed a new battery it believes will be less expensive to...

Q:

The Transportation Security Administration (TSA) examined the possibility of a Registered Traveler program. This program is intended to be a way to shorten security lines for trusted travelers. USA...

Q:

The following sample data have been collected for the purpose of testing whether a population standard deviation is equal to 40. Conduct the appropriate hypothesis test using = 0.05.