The information below is used for the questions that follow:

The Digital Alliance of Technical Associates (DATA) has the following tables for its DATA file.

Personal

Last_Name First_Name Emp_ID Address City State Zip Phone Hire_Date

Text 20 Text 15 Text 10 Text 25 Text 20 Text 2 Text 5 Text 15 Date

Employee Last Name Employee First Name Employee ID Number Permanent Address City State Abbreviation Zip Code Home Phone Date of Hire

Payroll

Emp_ID Pay_Rate Deductions Health Life

Text 10 Number Number Yes/No Yes/No

Employee ID Number Hourly Pay Rate Number of IRS Deductions Single Health Coverage Company Life Policy

HR (Human Resources)

Emp_ID Dept Hire_Date Performance Supervisor Projects

Text 10 Text 15 Date Memo Text 20 Text 50

Employee ID Number Assigned Work Dept. Date of Hire Comments on Performance Name of Boss Current Projects Assigned

Softball

Emp_ID Throws Bats Position

Text 10 Text 1 Text 1 Text 12

Employee ID Number Right or Left Right or Left Playing Position

1. What key field connects all the tables in this database? Why is this field preferable to their name or their Social Security number?

ANSWER:

2. HR needs a list of all employees who are due for their annual review. The annual review is done during the month the employee was hired. What should the table that HR needs look like so they can complete their review?

ANSWER:

5. The softball manager needs a list of players so they can be contacted about the upcoming season. What should the table look like?

ANSWER: