Answered step by step
Verified Expert Solution
Question
1 Approved Answer
6. the university has decided to increase the salary of instructors based on the following criteria. - If the instructor is in the computer since
6. the university has decided to increase the salary of instructors based on the following criteria. - If the instructor is in the computer since department and his/her salary is less than 70000 then his/her salary will be increased by 15% - If the instructor is in the electrical engineering department and his/her salary is less than 90000 then his/her salary will be increased by 8% - Instructors in other departments and have a salary of less than 70000 then his/her salary will be increased by 3.5% Please write a query that will show the instructor name, department name, salary, and salary after increase (2 Mark) 7. Define an SQL-procedure that will give name of courses that are taught in Watson. Please give your Procedure an appropriate name (2 Mark)
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