Question

need help

Project 1 Requirements Chocolate Arts Inc. needs your assistance in documenting its business processes for the payroll cycle for paying employees. The following is a narrative. Every Friday after calculating time and payroll, a second payroll clerk runs a database query to retrieve payroll information. This payroll clerk performs a random check of employee time and pay to verify accuracy and validity. Then the payroll clerk inserts check forms and paystubs into a dedicated laser printer and prints the paychecks and paystubs. The controller reviews the paychecks and signs the checks. The payroll clerk inserts the checks and stubs into window envelopes and mails the checks to employees. Requirements Complete the following for Chocolate Arts, Inc. 1. Annotate the narrative; label and number the events. 2. Create an Event-Agent Database (EAD) table. 3. Build level-O DFDs for each event in the EAD table and present a combined level-O DFD. Resources See the attached "DFD Supplemental Reading" file, including a description of "Ten Steps to Build a DFD". Use the "Ten Steps ..." as your guide to complete the requirements.

Answer 1

Table:
Employee(Emp_ID, First_name, Last_name, Emp_time, Emp_pay)

Entities:
Payroll Clerk
Controller

1. The annotated narrative is as follows:

S.NO. EVENTS 1.0 Payroll Clerk retrieves payroll information 2.0 Payroll Clerk verifies accuracy and validity. Payroll Clerk prints the paychecks and paystubs. Controller reviews the paychecks and signs the checks. Payroll Clerk mails the checks to the employees.

2. The Event-Agent-Diagram (EAD) table is as follows:

S.NO. EVENT AGENT DATA STORE Retrieve payroll information. Payroll Clerk Employee | 2.0 Verify accuracy and validity. Payroll Clerk | Employee 3.0 Print paychecks and paystubs. Payroll Clerk Employee 4.0 Review and sign paychecks. Controller Employee Mail checks to employees. Payroll Clerk Employee

3. The Level-0 DFDs for each event are as follows:

Event 1.0

Payroll Clerk Retrieve payroll information Employee Retrieves information Event 1.0: Level 0 DFD

Event 2.0

Verification Payroll Clerk Verify accuracy and validity Employee Event 2.0: Level 0 DFD

Event 3.0

Payroll Clerk Print paychecks and paystubs Employee Print Event 3.0: Level 0 DFD

Event 4.0

Controller Review and sign paychecks Employee Review and sign Event 4.0: Level 0 DFD

Event 5.0


Mail checks Payroll Clerk Mail checks to employees Employee Event 5.0: Level 0 DFD

The combined Level-0 DFD is as follows:

Payroll Clerk Retrieve information Print paychecks Mail pay checks Verification Payroll System Employee Information retrieval Review and sign paychecks /Paycheck information Controller