DEFINING ENTITIES AND DATA MODELING—PAYROLL Employees at the Sagerod Manufacturing Com...

DEFINING ENTITIES AND DATA MODELING—PAYROLL

Employees at the Sagerod Manufacturing 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 check register. The check register and corresponding paychecks reflect each employee’s net earnings for the period. Based on these records, the clerk prepares a payroll summary, which is sent with the paychecks to the cash disbursements clerk. The clerk reviews the payroll summary, updates the cash disbursements journal to record the total payroll, and prepares a check for the total payroll, which is deposited into the payroll imprest account. The clerk then 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. Create a data model for the system including the entities and cardinalities between them that 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.