Answered step by step
Verified Expert Solution
Question
1 Approved Answer
E bet365- Online Sports Bett DB1-52018-Comp353.pCOMP353-Summer-201 x file:/l/C:/u 18/comp353/COMP353-Summer-2018-Asg4.pdf [Part 2] Use triggers for the queries below: Create a trigger to ensure that a salary
E bet365- Online Sports Bett DB1-52018-Comp353.pCOMP353-Summer-201 x file:/l/C:/u 18/comp353/COMP353-Summer-2018-Asg4.pdf [Part 2] Use triggers for the queries below: Create a trigger to ensure that a salary of an employee cannot exceed the salary of his/her manager. If the employee does not have a manager, then his/her salary cannot be more than 10% of the highest salary in the database For changes in the job of an employee, updated details provided below must be written to Employee History: 6. 7. hire date of the employee for start date, old job ID, old department ID, Employee ID, todays' system date for end date. In case a row is already present for employee job history then the start date must be the end date of that (row +1) Make a Trigger to ensure that the salary of the employee is never decreased while working in an organization. Create a trigger to ensure that an increase of salary for an employee is conform with the following rules: If experience is more than 8 years, increase salary by max 20%; If experience is greater than 3 years, increase salary by max of 10%; Otherwise a max increase of 5% 8. 9. 10. Create a trigger to ensure that Min salary cannot exceed Max _salary for any job ENG 957 PM O Type here to search US 2018-08-17
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started