Question: Write trigger - empvac - which adds a record into a VACATION table for each EMPLOYEE who is INSERTed or UPDATEed into the EMPLOYEE table

Write trigger - empvac - which adds a record into a VACATION table for each EMPLOYEE who is INSERTed or UPDATEed into the EMPLOYEE table to ensure the difference between the HIREDATE and CURRENT DATE (SYSDATE) follows these rules:

- If employee was hired < 10 years ago - they get 3 weeks (15 days) vacation

- If employee was hired 10-19 years ago - they get 4 weeks (20 days) vacation

- If employee was hired 20-29 years ago - they get 5 weeks (25 days) vacation

- If employee was hired 30+ years ago - they get 6 weeks (30 days) vacation

If a record from the EMPLOYEE table is deleted - the associated record from the VACATION table should also be deleted.

VACATION Table Schema:

- EMPID

- HIREDATE

- VACATION DAYS

Step by Step Solution

★★★★★

3.34 Rating (148 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

create the trigger empvac as described youll need t... View full answer

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!

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...

The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...

Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...

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

1) (30 points) Employees may move to different departments. We want to keep track of the departments where each employee has been. To do so we create a new table EMP_DEPT that keeps track of such...

***SQL SERVER*** Use this for the database, https://www.dropbox.com/s/e4t28owml1u8z3i/PR.mdf?dl=0. For each exercise, include a header that has your name, the date, and the module number and exercise...

rigger and Stored Procedure: 1 . Write Triggers that logs any changes on Salary column of Employee table. Trig _ Update _ Audit _ EmpSalary to log any changes of salary by Update Trig _ Insert _...

CIS 205 Final Project Summer 2018 The final assignment consists of separating a database project into the phases that were outline during the semester. The project should be completed with the...

Please complete the attached worksheet thank you and highlight the answer in yellow see attachment Question 1 of 15 1. A small consulting company wants to make the switch to QuickBooks Online. All of...

(A) Watch the lecture video about "Trigger" and do the following tasks: A1. Explain the ROLE of trigger (30 words) A2. Create a trigger that when a workon record is added (namely, an employee works...

Howard Electronics, a small manufacturer of electronic research equipment, has approximately 7,000 items in its inventory and has hired Joan Blasco-Paul to manage its inventory. Joan has determined...

A van de Graaff generator has a metal sphere of radius 15 cm. To what potential can it be charged before the electric field at its surface exceeds 3.0 106 N/C (which is sufficient to break down dry...

Which word best replaces evolve as it is used in paragraph 1 ? A . adapt B . develop C . increase D . mature

On January 1, 2021, the company obtained a $3 million loan with a 10% interest rate... The building was completed on September 30, 2022. Expenditures on the project were as follows: January 1, 2021...

Rotation of the arm OP is controlled by the horizontal motion of the vertical slotted link. If x = 4 ft/sec and x = 30 ft/sec 2 when x = 2 in., determine and for this instant. A -P Problem 2/237

Which of the following homogeneous liquids are elements, which are compounds, and which are solutions: alcohol, mercury, liquid hydrogen, pure water, seawater, beer?

Do piano lessons improve the spatial-temporal reasoning of preschool children? A study designed to investigate this question measured the spatial-temporal reasoning of a random sample of 34 preschool...

Why is the internal rate of return from human capital investment subject to diminishing returns? Explain the rationale for identifying the diminishing rate of returns to education curve as the demand...

A qualified long-term care insurance policy must contain which of the following requirements? A) Coverage for drug and alcohol dependency B) Coverage for conditions that result from warC) Guaranteed...

Reread the case descriptions in Chapters 1 through 3 with an eye toward identifying the typical types of reports and displays the various stakeholders might want to retrieve from your database....

List the customers who live in California or Washington. Order them by zip code, from high to low.

Figure 2-27 represents a situation of students who attend and work in schools and who also belong to certain clubs that are located in different schools. Study this diagram carefully to try to...

The NPD Group recently released its annual U.S. Video Game Industry Retail Sales Report. The report contained the NPD Groups selection of the top 10 video games based on units sold. The top-selling...

In an article titled Airport Screeners Strains, Sprains Highest among Workers, Thomas Frank reported that the injury rate for airport screeners was 29%, far exceeding the 4.5% injury rate for the...

The Future-Vision Company is considering applying for a franchise to market satellite television dish systems in a Florida market area. As part of the companys research into this opportunity, staff...