Employees at the Harvest Equipment Company record their hours worked on paper time cards that are inserted into a time clock machine at the beginning and end of each shift. On Fridays, the supervisor collects the time cards, reviews and signs them, and sends them to the payroll clerk. The clerk calculates the pay for each employee and updates the employee earnings file. This involves adding a new record for each employee in the pay period that reflects the employee’s gross pay, tax deductions, and other withholdings for the period. The clerk then prepares a paycheck for each employee and records it in the paycheck register. The paycheck register reflects each employee’s net earnings for the period. The clerk then prepares a payroll summary and sends the summary and paychecks to the cash disbursements clerk who reviews them and updates the cash disbursements journal to record the total payroll. The clerk then prepares a single check for the total amount and deposits the check into the payroll imprest account. Finally, the clerk signs the paychecks, and distributes them to the employees. 

Required

Assume that the manual system described is to be automated using a relational database system. Prepare an entity level data model that contains only entities and shows the cardinalities between them (no attributes are required), which will support the tasks and user views depicted in the description. You may need to make assumptions about how certain automated activities will be performed. Normalize the model.