We introduced an employee-payroll hierarchy to calculate each employee’s payroll. In this exercise, we provide a database of employees that corresponds to the employee-payroll hierarchy. (A SQL script to create the Employees database is provided with the examples for this chapter.) Write an application that allows the user to:

a) Add employees to the Employee table.

b) Add payroll information to the appropriate table for each new employee. For example, for a salaried employee add the payroll information to the SalariedEmployees table. Figure 24.35 is the entity-relationship diagram for the employees database.

Figure 24.35

salaried Employees social SecurityNumber weeklySalary bonus hourlyEmployees social SecurityNumber hours wage bonus employees social SecurityNumber firstName lastName birthday employee Type departmentName commission Employees social SecurityNumber gross Sales commissionRate bonus basePluscommission Employees social SecurityNumber grossSales commissionRate baseSalary bonus