Suppose that the company from problem 1 has a table describing employees of the company which contains the

following information:

Employee last name

Employee first name

Employee number (Each employee has a different number assignment by the company.)

Coporate email (Each employee has a different email.)

birth date

home address

company phone number (Not all employees have a separate line.)

home phone number

Home addresses and home phone numbers may not be unique as married couples do work at the company.

The IT department keeps another table that links workstations to the employees to whom they are assigned. Each

employee has a workstation.

a. Write the table schema for the two tables described above. Use the format from problem 1 for the schema.

b. Identify the primary and alternate keys for the two tables. You do not have to identify the superkeys.

c. Identify the necessary foreign keys in the IT department's table to link the employees and workstations.