Answer to Question #268516 in Databases | SQL | Oracle | MS Access for Lee

Question

Write a pl /SQL to determine whether salaries for members of the staff need to be adjusted or not. Depending on the work load (number of subjects), lectures need to get an increase. Management has decided that whoever teaches 2 or more subjects should get 15% increase on the salary. If prompt for staff identification number and display this data accordingly.

Answer 1

Enter value for staff_number: 513500

Mr/Mrs MOORE teaches 2 subjects

ATTENTION: This lecturer is eligible for an increase

The current salary is:          R78000 - The new salary is:          R89700

 

Enter value for staff_number: 502501

Mr/Mrs MARK teaches 1 subjects

ATTENTION: This lecturer is not eligible for an increase