ACG 4401

1. ACG 4401 Data Model Examples: DFD’s and System Flowcharts

2. 0 Employee Tax Form Employee Payroll System Payroll Report Time Sheet Employee Payroll Check Context-Level Diagram Employee Accounting Department 21

3. Employee Data File Payroll Data File 2.0 Employee Record Paycheck Data Employee Compute Weekly Paycheck S1 S2 Payroll Record Hours Worked 3.0 1.0 Employee Payroll Record Prepare Weekly Payroll Summary Create Weekly Payroll Record Time Sheet Employee Paycheck Payroll Report 4.0 Prepare Employee Tax Form Employee Tax Form Accounting Department Level-0 DFD 22

4. 1.0 4.1 2.1 4.2 2.2 3.1 2.3 3.2 Employee Data File Payroll Data File S1 S2 Employee Record Compute Gross Pay Create Payroll Check Print Weekly Payroll Summary Compute Net Pay Print Employee Tax Form Calculate Payroll Deductions Sort Payroll Records by Employee Create Weekly Payroll Record Payroll Record Hours Worked Gross Pay Data Net Pay Data Time Sheet Sorted Records Employee Paycheck Payroll Report Employee Payroll Record Payroll Deductions Employee Tax Form Level-1 DFD Employee Accounting Department 23

5. 4.1.1 4.1.2 4.1.3 4.2.1 4.2.2 Employee Payroll Record Print Employee Tax Form Calculate Payroll Tax Deductions Calculate Employee Vacation Pay Calculate Retirement Allowance Calculate Non-tax Deductions Employee Tax Form Employee Data Employee Data Employee Data Employee Data Functional Primitive 24

6. The data-entry clerk keys in an input document into the computer. The computer accesses data in a data store 1 and in data store 2 to edit/validate the input. The computer displays the input, including any errors. The clerk compares the input document to the display, keys corrections as necessary, and accepts the input. The computer updates the table in data store 2 and notifies the clerk that the input has been recorded. 44

7. User queries the computer. The computer accesses the table(s) in one of more data stores & presents a response to the user. Update sequentialdata store from magnetic disk are input to the computer, along with the existing (old) master data – becoming the new master data 45

8. The user batches the input documents, prepares batch totals, and keys the documents into the computer. The computer records the inputs on disk and notifies the user as each input is accepted. The user files the input documents in numerical sequence. At the end of the batch, the computer prepares an exception & summary report that includes batch totals. The user compares the computer batch totals to those prepared earlier. 46

9. A data entry clerk enters documents into a networked PC system. The system records the inputs on a disk and notifies the user of the acceptance of each input. The documents are then forwarded to a different clerk who keys the documents again. Differences are resolved and the event data are updated to reflect the verifications and corrections. 47

10. A clerk scans a document into the computer. Use the data from the scanned document, the computer updates the data store(s) 48

11. A clerk scans a document into the computer. The computer routes an image of the scanned input to a data entry clerk, who keys data from the documents image into the computer. The computer records the data with the scanned document 49