Reference no: EM133239645

Instructions: Draw an extended entity relationship diagram (REA format preferred) and a matching data flow diagram. Please note that you will need to design the resulting tables and show the PK and FKs in the relation between the tables.

Employees follow established procedures for submitting their timesheets (online). The submitted requests are accumulated and at the end of the week, the system notifies their supervisor of the submitted requests and obtains supervisor approval. Employees have one and only one supervisor and a supervisor may have many employees underneath her, but she must have a minimum of one employee. Therefore, the timesheet reporting process always involves one and only one employee, but the timesheet approval process may relate to multiple timesheet requests/employees and thus timesheet records as well.

Each pay period, the payroll clerk verifies the hours and pay rate & positions listed on the timesheets with the Payroll master file and determines if there is an error. The payroll transaction process will document any errors in the errors file and notify the supervisor of the employee. Those with no errors will get the withholding for taxes (which is looked up from the tax rates table), and the payroll amount is calculated and stored in the payroll transaction file. The timesheets file will get updated to reflect that they have been approved for final payment.

For each employee on the payroll transaction file, the payroll cash disbursement (payment) process will issue a check payment to the employee for the amount along with deductions in a paystub. The payroll cash disbursement process will be drawn from one of our cash (checking) accounts and so the payment process can relate to only one (max one) cash checking account (account details are also on the payroll check). The employee can receive many or none payments (new employees may not have been paid even though we started tracking their deposit account number) but a payment is issued for one and only one employee. At this point, the system automatically updates the timesheets will get updated to reflect that they have been paid. The payroll cash disbursement voucher is also created and sent to the General Ledger department.