The table structure shown in Table $1$ contains many unsatisfactory components and characteristics. For example, there are several multi$-$valued attributes, naming conventions are violated, and some attributes are not atomic.

$\backslash$table$[[$Attribute Name,Sample Value,Sample Value,Sample Value,Sample Value$],[$EMP$\_$NUM,$1003,1018,1019,1023],[$EMP$\_$LNAME,Willaker,Smith,McGuire,McGuire$],[$EMP$\_$EDUCATION,BBA, MBA,BBA,,BS$,$ MS$,$ Ph$.$D$.],[$JOB$\_$CLASS,SLS$,$SLS$,$JNT$,$DBA$],[$EMP$\_$DEPENDENTS,$\backslash$table$[[$Gerald $($spouse$),],[$Mary $($daughter$),],[$John $($son$)]],,$JoAnne $($spouse$),\backslash$table$[[$George $($spouse$)]]],[,$MKTG$,$MKTG$,$SVC$,$Jill $($daughter$)],[$DEPT$\_$CODE,Marketing,Marketing,General Service,Info. Systems$],[$DEPT$\_$NAME,Jill H$.$ Martin,Jill H$.$ Martin,Hank B$.$ Jones,Carlos G$.$ Ortez$],[$DEPT$\_$MANAGER,Sales Agent,Sales Agent,Janitor,DB Admin$],[$EMP$\_$TITLE,$23-$Dec$-1968,28-$Mar$-1979,18-$May$-1982,20-$Jul$-1959],[$EMP$\_$DOB,$14-$Oct$-1997,15-$Jan$-2006,21-$Apr$-2003,15-$Jul$-1999],[$EMP$\_$HIRE$\_$DATE,L$1,$ L$2,$L$1,$L$1,$L$1,$ L$3,$ L$8,$ L$15],[$EMP$\_$TRAINING,$$38,255\mathrm{.}00,$$$30,500\mathrm{.}00,$$$19,750\mathrm{.}00,$$$127,900\mathrm{.}00],[$EMP$\_$BASE$\_$SALARY,$0\mathrm{.}010,,,],[$EMP$\_$COMMISSION$\_$RATE,$0\mathrm{.}015,,,]]$

Table $1$: Table Structure

Given the structure shown in Table $1,$ write the relational schema and draw its dependency diagram. Label all transitive and$/$or partial dependencies. $[5$ points$]$

Draw the dependency diagrams that are in $3$NF$.($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$.)[6$ points$]$

Draw the Crow's Foot ERD. $[9$ points$]$