a) The following table structure contains unsatisfactory components and characteristics. (For example, there are several multivalued attributes, some attributes are not atomic, and so on.) Given this structure, draw its dependency diagram. Label all transitive and/or partial dependencies.

b) Redesign the database to 1NF

c) Redesign the database to 2NF. Show all the steps.

d) Redesign the database to 3NF. Show all the steps.

Attribute name EMP CODE LAST NAME FIRST NAME EDUCATION DEPT CODE DEPARTMEN1T DEPT MANAGER JOB CLASS TITLE DEPENDENTS BIRTH DATE HIRE DATE TRAINING BASE SALARY OFFICE EXTENSION Sample value 1003 Willaker Taylor HS, BS DBADMIN Marketing Jill H. Martin 23 Database analyst Gerald (spouse), Mary (daughter), John (son) 12/23/92 10/14/2016 Level 1, level 2 $62,255 MCL1302 2600