Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Every two weeks, employees of a manufacturing form submit their time cards to the supervisor, who reviews and approves them. They are the submitted to

Every two weeks, employees of a manufacturing form submit their time cards to the supervisor, who reviews and approves them. They are the submitted to the payroll department. At the time, the human resources clerk also submits a personnel action to the payroll clerk. The payroll clerk enters the information from these source documents into the employee hours to a payroll register reflecting employee pay rates, deductions, and job classification. One copy of the payroll register, along with the time cars, is filed in the payroll department, and one copy is sent to the AP department. Next the payroll clerk sends the employee paychecks to the cash disbursements department. The checks are signed and distributed to the employees by the paymaster. The AP department prepares a cash disbursements voucher. A copy of the voucher and a copy of the payroll register are sent to the cash disbursements department and are then posted to the general ledger. The cash disbursements clerk writes a check for the entire payroll and deposits it in the payroll imprest cash account. A copy of the check, the disbursement voucher, and the payroll register are sent back to the AP department, where they are filed. Required: a. Prepare the REA model of the payroll process b. Show the cardinalities for all associations c. List the tables, keys, and attributes needed to implement this model in a relational database

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals of Cost Accounting

Authors: William Lanen, Shannon Anderson, Michael Maher

3rd Edition

9780078025525, 9780077517359, 77517350, 978-0077398194

Students also viewed these Accounting questions

Question

Focus on the interview.

Answered: 1 week ago