The Accounting Services Company wants to store data about its employees skills. Each employee may possess one or more specific skills and several employees may have the same skill.

a. What is the maximum cardinality between a table of employees and a table of skills?

b. The Accounting Services Company plans to include the following attributes in their database:

date hired

date of birth

date skill acquired

employee name

employee number

employee level

pay rate

skill name

skill number

department assigned

department #

department supervisor

Each employee is assigned to one department. All department supervisors are also employees.

Design an REA diagram of relational tables required to accomplish the above in 3^rd normal form. (Use the format that we did for the student-class exercise). Include the minimum and maximum cardinalities between tables. Only Table Names are required on this document.

c. After completing part b, complete the below table for UML documentation purposes. Note the attributes agreed to in b.

File Name	Primary Key	Foreign Keys	Other Attributes