Reference no: EM131554135

1. Create two PL/SQL blocks that will insert or delete rows from the employee deduction table. Include exception processing for bad input data and verify that an employee is eligible for a deduction based upon their salary grade. Salary grade is determined by checking the salary grade table to derive the employee's salary grade. Once you know an employee's grade, then verify if the employee is eligible for the deduction (e.g. 401K) via comparing it to the minimum and maximum salary grade that is stored in the deduction table ( see definition above).