You are required to determine what data will be included in each of the following files to generate the following reports:

Files

Employee Master File

Time Card File

Job File

Reports

Pay checks

W-2 Statements

Job Reports by Customer

You should avoid duplication of information in multiple files but ensure that you can generate the three reports. You can have multiple entries of the same type per data entry (e.g. there can be multiple jobs on a time card). You do not have to indicate which data files may allow multiple entries per file. Also realize that numbers can be aggregated to get certain totals (e.g. annual salary for W-2s).

This assignment should be brief but requires some thought. Please place Xs in the appropriate column of the attached spreadsheet.

DATA: Employee Master File Time Card File Job File

Employee #

Social Security #

Emp FirstName

Emp LastName

Emp Address1

Emp City

Emp State

Emp ZipCode

Emp MaritalStatus

Emp Exemptions

Emp WageRate

Time Card #

Time Card Date

Time Card Hours

Job #

Job Description

Job Hours

Customer #