Homework Assignment: PL/SQL

First Problem:Write a PL/SQL program to accomplish the following: Using the sample emp database, give everyone in dept 30 a 5% raise, everyone in dept 20 a 7.5% raise, everyone in department dept 10 a 10% raise. Do this using a simple IF...ELSE and a loop.

Second Problem:Modify the program above to use a IF...ELSIF.

Third Problem:Modify the problem in #1 to meet the following criteria:
IF dept is 10 and the salary is greater than 2000 give a 6% raise otherwise give a 7% raise. IF dept is 20 and the salary is greater than 2500 give a 5% raise otherwise give a 5.5% raise. IF dept is 30 and the salary is greater than 1000 give a 7% raise otherwise give a 6.5% raise.

Fourth Problem:Write a PL/SQL program to accomplish the following using two loops and a cursor: One loop to go through all of the records on the table and a FOR loop to handle the quarterly salary.
Assume the salary information in the table is weekly salary.
Create a table that will have four records for each employee with the following information for each employee: employee number, employee name, quarter number (1 for the first quarter etc), quarter salary. Note you are writing one record for each quarter for each employee, so an employee will have a record for quarter 1, a record for quarter 2 etc.