Answered step by step
Verified Expert Solution
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
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 databaseStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started