Question: Create a trigger named employeeDeleteTR that will prevent an employee record from being deleted. The result of any such action should result with a. the

Create a trigger named employeeDeleteTR that will prevent an employee record from being deleted. The result of any such action should result with a. the employees vacation hour and sick leave hours being set to zero, b. the EmployeeDepartmentHistory table being updated with the end date for the employee being set to the current date c. display an informational message to the user indicating employee separation date has been recorded (Include the employee name in the text of the message).

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock 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!

Create questions and answers with the following FIELD OPERATIONS DIVISION DISTRICT PATROL STANDARD OPERATING PROCEDURES LETTER OF PROMULGATION TO: All Patrol District Personnel: ARTHUR NORIEGA, V...

Describe one specific section which surprised you. Explain the concept that was surprising and explain why I Self-Management Copyright 2007. Arnacorn. All rights reserved. Selfmanagement happens when...

Appendix C Contract Negotiation Simulation Clean Right Partners Inc You will be provided with further information and instructions regarding the analysis and a possible renewal of the collective...

this is a report for HR in this report i'm from the union side i have to make a Indivdual Strategy Report and Indivdiual Final report the following pics will give u all the details please please help...

*choose any 2 of the student activities to do* Although PAC Resources is a fictional organization, it experiences many of the difficulties common in today's business climate. In response to declining...

Americans with Disabilities Act (ADA) and ADA Amendments Act (ADAAA) The Americans with Disabilities Act of 1990 (ADA) prohibits discrimination against disabled workers or job applicants and covers...

Need a well written Reflection paper. For class Compensation and Benefits (MGT3349) Download The attachment and follow the instruction Need a well written Reflection paper. For class Compensation and...

strategic staffing 4thedition by philips.. chern' s case study APPENDIX Strategic Staffing at Chern's: A Case Study CHERN'S COMPANY HISTORY AND ORGANIZATION Siblings Ryan and Ann Chern founded...

Flag question: Question 1 Question 1 1 pts A client wants to reduce the property's hazard insurance coverage substantially, in order to save money on the premiums. If the property manager tries to...

A refrigeration machine is required to produce i.e., at 0C from water at 20C. The machine has a condenser temperature of 298 K while the evaporator temperature is 268 K. The relative efficiency of...

The critical argument summary gives you the opportunity to start formally interacting with some of the literary criticism on your author, work, and/or topic, as well as giving you the opportunity to...

What are the key differences between a regular bit and a qubit? What is the difference between a regular computer and a quantum computer? 5 points

10) For a bond that pays cash interest (i.e., not a zero coupon bond), YTM is (a) always equal to the coupon rate (b) always equal to the current yield (c) is always less than the coupon rate (d) can...

Ethics.Technology. Company officials searching for a way to avoid bankruptcy raised cash with off-the-balance-sheet loans and overstated results by inflating capital expenses and hiding the debt.The...

Technology. Ethics. A friend gives you a copy that he has made of a software program that he purchased. Is this a legal or an ethical issue or both? Explain your answer in an e-mail sent to your...

Technology. Ethics. Send an e-mail to your instructor describing an ethical or legal communication that you had to handle at your job or in the classroom. Apply the ethical principles described in...