Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Payroll DFD Hourly employees in each university department provide their departmental secretaries with their weekly timecards. The departmental secretary accesses the employees' data from the

Payroll DFD

Hourly employees in each university department provide their departmental secretaries with their weekly timecards. The departmental secretary accesses the employees' data from the Employee Payroll File and prepares a Weekly Time Sheet that lists each employee's name, social security number, and total hours worked. The time sheet also notes whether the employee is a student. Then the departmental secretary files the timecards in a Timecard History File and sends the time sheet to the university's payroll department. In the payroll department, a payroll clerk uses the Employee Payroll File to calculate thepay amount for each employee and then uses the earnings, deductions, and the amount of the paycheck to update the year-to-date data for each employee in the Employee Payroll File. If the employee is a student, the clerk checks the Financial Hold List. If the employee is on the list, a copy of the employees Employee Payroll File is sent to the Office of the Bursar for further action. Otherwise, the clerk prepares the payroll checks, which are forwarded to employees. Externals: Employee, Office of the Bursar

Please label Data Flows as data

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

SQL Server T-SQL Recipes

Authors: David Dye, Jason Brimhall

4th Edition

1484200616, 9781484200612

More Books

Students also viewed these Databases questions