For a database management course. Using the attributes given, redesign in 1NF, 2NF, and 3NF showing all steps

Questions #2: 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. Attribute name EMP CODE LAST NAME FIRST NAME EDUCATION DEPT CODE DEPARTMENT 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 b) Redesign the database to INF c) Redesign the database to 2NF. Show all the steps. d) Redesign the database to 3NF. Show all the steps