Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can i ask you this REA model question please ? c. List the tables, keys, and attributes needed to implement this model in a relational

image text in transcribed

can i ask you this REA model question please ?

c. List the tables, keys, and attributes needed to implement this model in a relational database. d to base. 9. REA MODEL-PAYROLL SYSTEM Every two weeks, employees of a manufacturing firm C. le MP3 submit their time cards to the supervisor, who reviews and approves them. They are the submitted to the payroll department. At that time, the human als such esources clerk also submits a personnel action to the version payroll clerk. The payroll clerk enters the informa- rchases tion from these source documents into the employee records and then adds the employee hours to a pay- roll register reflecting employee pay rates, deduc- tions, and job classification Oe copy of the payroll register, along with the time cards, is filed in the payroll department, and one copy is sent to nonitors a pur cessary prepares are sent pen pur- ent, and al. Each paresa the AP department. Next, the payroll clerk sends the employee pay- checks 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 o each 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, receiving the disbursement voucher, and the payroll register are recerving sent back to the AP department, where they are filed. nai and sting. cash dis als ware- artment. Required date eh. a. Prepare the REA model of the payroll process. date the d in the der and o the AP b. Show the cardinalities for all associations c. List the tables, keys, and attributes needed to implement this model in a relational database. c. List the tables, keys, and attributes needed to implement this model in a relational database. d to base. 9. REA MODEL-PAYROLL SYSTEM Every two weeks, employees of a manufacturing firm C. le MP3 submit their time cards to the supervisor, who reviews and approves them. They are the submitted to the payroll department. At that time, the human als such esources clerk also submits a personnel action to the version payroll clerk. The payroll clerk enters the informa- rchases tion from these source documents into the employee records and then adds the employee hours to a pay- roll register reflecting employee pay rates, deduc- tions, and job classification Oe copy of the payroll register, along with the time cards, is filed in the payroll department, and one copy is sent to nonitors a pur cessary prepares are sent pen pur- ent, and al. Each paresa the AP department. Next, the payroll clerk sends the employee pay- checks 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 o each 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, receiving the disbursement voucher, and the payroll register are recerving sent back to the AP department, where they are filed. nai and sting. cash dis als ware- artment. Required date eh. a. Prepare the REA model of the payroll process. date the d in the der and o the AP 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 to Expert-Tailored 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

Access Audit Handbook

Authors: (CAE) Centre For Accessible Environments

2013th Edition

1859464920, 978-1859464922

More Books

Students also viewed these Accounting questions