Subject : Accounting Information Systems Development

Required: 1. Identify tables and attributes needed in the payroll procedures. 2. Create the entity relationship. Also mention PK and FK.

Accounting Information System Development The following describes the payroll procedures for MS Corp. Every Thursday, the timekeeping clerk sends employee time cards to the payroll department for processing. Based on the hours worked reflected on the time cards, the employee pay rate and withholding information in the employee file, and the tax rate reference file, the payroll clerk calculates gross pay, withholdings, and net pay for each employee. The clerk then manually prepares paychecks for each employee, files hard copies of the paychecks in the payroll department, and posts the earnings to the hard-copy employee records. Finally, the clerk manually prepares a payroll summary and sends it and the paychecks to the cash disbursements department. The cash disbursements clerk reconciles the payroll summary with the paychecks and manually records the transaction in the hard-copy cash disbursements journal. The clerk then files the payroll summary and sends the paychecks to the treasurer for signing. The signed checks are then sent to the paymaster, who distributes them to the employees on Friday morning. Accounting Information System Development The following describes the payroll procedures for MS Corp. Every Thursday, the timekeeping clerk sends employee time cards to the payroll department for processing. Based on the hours worked reflected on the time cards, the employee pay rate and withholding information in the employee file, and the tax rate reference file, the payroll clerk calculates gross pay, withholdings, and net pay for each employee. The clerk then manually prepares paychecks for each employee, files hard copies of the paychecks in the payroll department, and posts the earnings to the hard-copy employee records. Finally, the clerk manually prepares a payroll summary and sends it and the paychecks to the cash disbursements department. The cash disbursements clerk reconciles the payroll summary with the paychecks and manually records the transaction in the hard-copy cash disbursements journal. The clerk then files the payroll summary and sends the paychecks to the treasurer for signing. The signed checks are then sent to the paymaster, who distributes them to the employees on Friday morning