How would I go about doing these? I cant tell if the way I am doing it is correct or not?

1018 1019 McGuire Smith EMP_NUM EMP_LNAME EMP_EDUCATION JOB_CLASS EMP_DEPENDENTS BBA SLS 1023 McGuire BS, MS, Ph.D. DBA George (spouse) Jill (daughter) JNT JoAnne (spouse) DEPT_CODE DEPT_NAME DEPT_MANAGER EMP_TITLE EMP_DOB EMP_HIRE_DATE EMP_TRAINING EMP_BASE_SALARY EMP_COMMISSION RATE 1003 Willaker BBA, MBA SLS Gerald (spouse), Mary (daughter), John (son) MKTG Marketing Jill H. Martin Sales Agent 23-Dec-1968 14-Oct-1997 L1, L2 $38,255.00 0.015 MKTG Marketing Jill H. Martin Sales Agent 28-Mar-1979 15-Jan-2006 L1 $30,500.00 0.010 SVC General Service Hank B. Jones Janitor 18-May-1982 21-Apr-2003 L1 $19,750.00 INES Info. Systems Carlos G. Ortez DB Admin 20-Jul-1959 15-Jul-1999 L1,L3,L8,L15 $127,900.00 a. Given the structure shown in Table P6.6, write the relational schema and draw its dependency diagram. Label all transitive and/or partial dependencies. b. Draw the dependency diagrams that are in 3NF. (Hint: You might have to create a few new attributes. Also make sure that the new dependency diagrams contain attributes that meet proper design criteria; that is, make sure there are no multivalued attributes, that the naming conventions are met, and so on.) c. Draw the relational diagram. d. Draw the Crow's Foot ERD. Use the dependency diagram shown in Figure P6.8 to work the following problems. a. Break up the dependency diagram shown in Figure P6.8 to create two new dependency diagrams: one in 3NF and one in 2NF. b. Modify the dependency diagrams you created in Problem sa to produce a set of dependency diagrams that are in 3NF. (Hint: One of your dependency diagrams should be in 3NF but not in BCNF.) c. Modify the dependency diagrams you created in Problem 8b to produce a collection of dependency diagrams that are in 3NF and BCNF. FIGURE P6.8 INITIAL DEPENDENCY DIAGRAM FOR PROBLEM 8 B D E F G