Read Case #4 background information. All subsequent parts to this problem require that you have read the case background and completed part a. REQUIRED: Determine that the record count and totals for the two tables are consistent with the information provided by the IT department.

Read Case #4. Determine that all employees on the Eastland_Payroll_Trans table are included in the Eastland_Payroll_Master table.

Read Case #4. Determine that employees hired on November 1 and December 1 were paid only for the months they were employed.

Read Case #4. Compare the monthly salary for each month on the payroll transaction table with information in the payroll master table.

Read Case #4. Determine if the December bonus payment for each employee is consistent with the policy established by the board of directors. Employees who earn less than $40,000 are trainees and do not receive a bonus.

Read Case #4. Recalculate the net amount paid to each employee for both salaries and bonuses.

Read Case #4. Account for all check numbers issued during the period, including both missing check numbers and duplicates. The first check number issued in October was 65785 and the last one issued was 67537.

Read Case #4. Compare total salaries, not including the December bonus, for each department and assess whether the amounts appear reasonable.