First, identify a list of all the entities in the problem. And make an ERD is based on the top-down design. Then, using the concept of bottom-up design and normalization, design a database based on the enclosed Employee data. Study the data carefully to understand the relationships. Note that each job_class belongs to a specific department, for example job_class JNT (Janitor) belongs to SVC (General Services) department. Please ensure that in your final design ERD all the relations are in 3NF and the relationships are properly established, i.e., the database is fully integrated. Your design should provide for the storage of the all the data. You are provided few employee records that are stored in columns as sample data for your analysis.

Attributes

EMP_NUM EMP_LNAME EMP_EDUCATION JOB_CLASS EMP_DEPENDENTS

DEPT_CODE DEPT_NAME DEPT_MANAGER EMP_TITLE EMP_DOB EMP_HIRE_DATE EMP_TRAINING EMP_BASE_SALARY EMP_COMMISSION_RATE

TABLE P5.1 SAMPLE EMPLOYEE RECORDS SAMPLE VALUE SAMPLE VALUE SAMPLE VALJE SAMPLE VALUE 1003 1018 1019 1025 Willaker Smith McCuire McGuire ATTRIBUTE NAME EMP_NUM EMP_LNAME EMP EDUCATION JOB CLASS EMP DEPENDENTS BBAMBA BBA BS, MS, Ph.D SLS INT DOBA PoAnne spousel Ceonge spouse Ill douchter MKTG SVC INES Into Systems Carlos Gi Orte SLS Gerald (spouse) Mary daughter, Johnson) Marketing Jill H. Martin Sales Agent 23-Dec-1968 14-04-1992 L1, L2 $38.255.00 0.013 General Service Hank B Jones anitor DEPT_CODE DEPT NAME DEPT MANAGER EMP_TITLE EMP DOR EMP HIRE DATE EMP TRAINING EMP BASE SALARY EMP COMMISSION RATE Marketing BUH. Martin Sales Agent 28-Mar1979 DB Admin 20-10-1939 15-Jan-2004 18-May-1982 21-Apr-2003 LI 1.5lul 1999 615 $30.500.00 $19.750.00 52.900.00 0001 TABLE P5.1 SAMPLE EMPLOYEE RECORDS SAMPLE VALUE SAMPLE VALUE SAMPLE VALJE SAMPLE VALUE 1003 1018 1019 1025 Willaker Smith McCuire McGuire ATTRIBUTE NAME EMP_NUM EMP_LNAME EMP EDUCATION JOB CLASS EMP DEPENDENTS BBAMBA BBA BS, MS, Ph.D SLS INT DOBA PoAnne spousel Ceonge spouse Ill douchter MKTG SVC INES Into Systems Carlos Gi Orte SLS Gerald (spouse) Mary daughter, Johnson) Marketing Jill H. Martin Sales Agent 23-Dec-1968 14-04-1992 L1, L2 $38.255.00 0.013 General Service Hank B Jones anitor DEPT_CODE DEPT NAME DEPT MANAGER EMP_TITLE EMP DOR EMP HIRE DATE EMP TRAINING EMP BASE SALARY EMP COMMISSION RATE Marketing BUH. Martin Sales Agent 28-Mar1979 DB Admin 20-10-1939 15-Jan-2004 18-May-1982 21-Apr-2003 LI 1.5lul 1999 615 $30.500.00 $19.750.00 52.900.00 0001