Our task is the creation of a new payroll system. The old system is outdated and no longer adequately manages the payroll process and the entry of employee time card information. Therefore, manual intervention is required to process the payroll. In addition to the preexisting category of salaried employee, which the current payroll process does support, our organization now accommodates two new types of employees: those employees working on commission, and those employees working on an hourly basis. The current payroll process doesn't support these two new employee types, which are described in detail later in this problem statement. In addition to accommodating all employee types, as well as ensuring that our system can accommodate newly created categories of employees in the future, the system must also allow each of these employees to enter his or her time information via a corporate intranet using a standard Web browser. Because employees can manage only their individual time card information, a user ID and password is required of each employee prior to gaining access to this section of the corporate intranet. The payroll process can process only "signed" time cards, which are those time cards that the employee has identified as accurate. Overall, the system will store information about the approximately 2,000 company employees. This data will be stored in the Oracle payroll database. The payroll process must run on the fifteenth and last day of each month at 12:00 a.m. All paychecks must be accurately calculated and deposited into one or more bank accounts of the employees' choosing. Employees also should be able to change personal information, such as names, addresses, and passwords. Eventually, the system must enable employees to maintain their direct deposit information via the system as well. However, this feature is beyond the scope of the initial release. A human resources representative must be able to initiate the
Our task is the creation of a new payroll system. The old system is outdated and no longer adequately manages the payroll process and the entry of employee time card information. Therefore, manual intervention is required to process the payroll. In addition to the preexisting category of salaried employee, which the current payroll process does support, our organization now accommodates two new types of employees: those employees working on commission, and those employees working on an hourly basis. The current payroll process doesn't support these two new employee types, which are described in detail later in this problem statement. In addition to accommodating all employee types, as well as ensuring that our system can accommodate newly created categories of employees in the future, the system must also allow each of these employees to enter his or her time information via a corporate intranet using a standard Web browser. Because employees can manage only their individual time card information, a user ID and password is required of each employee prior to gaining access to this section of the corporate intranet. The payroll process can process only "signed" time cards, which are those time cards that the employee has identified as accurate. Overall, the system will store information about the approximately 2,000 company employees. This data will be stored in the Oracle payroll database. The payroll process must run on the fifteenth and last day of each month at 12:00 a.m. All paychecks must be accurately calculated and deposited into one or more bank accounts of the employees' choosing. Employees also should be able to change personal information, such as names, addresses, and passwords. Eventually, the system must enable employees to maintain their direct deposit information via the system as well. However, this feature is beyond the scope of the initial release. A human resources representative must be able to initiate the