High Level Classes

1) EMPLOYEE Class containing basic information for each employee EmployeeID, FirstName, LastName, ModdileInitial, DOB, HIRE_DT, SSN EmployeeID uniquely identifies each instance of this class.

2) SKILL Class contains master list of all the skills, each instance of this class contains SkillCode (unique), Description of the skill Example: SkillCode Description 1 Java Programming 2 .Net Programming 3 Business Analysis 4 Project Management 5 Application Architecture 6 Infrastructure Architecture

3) SKILL_LEVEL Class contains Levels of skills. Each instance contains SkillLevelCode (unique), and a brief description. Example: SkillLevelCode Description 1 Proficient 2 Advanced 3 Expert

What you need to do:

1) Based on the above information, Identify the class structure for EMPLOYEE_ASSESSMENT. This class represents employees self-assessment of various skills. For example, John says he is an expert in Java Programming, Proficient in Business Analysis; Kelly says she has advanced skills in Project Management, proficient in .Net Programming and is an expert in Business Analysis. (2 points)

2) Identify the primary keys for each of the classes (including the high level classes above). (1 point)

3) Identify relationships amongst the classes and show them pictorially (data model diagram). Show cardianilties. (2 points) 4) List the foreign keys (if any), for each class and get a 0.25 extra credit point.

4) List the foreign keys (if any), for each class and get a 0.25 extra credit point.