Observe the following table with sample data about employees working in various projects. The underlined is the primary key.

Each project has a unique project id and a project name.

Each employee has a unique employee id$,$ a name, and a job class.

Each job class has a pay rate per hour.

Each employee can work in a number of projects.

A number of employees can work in the same project.

Each employee only has one job class.

$\backslash$table$[[$ProilD$,$ProjName,EmpID,EmpName,JobClass,HourlyRate,Hours$],[25,$Evergreen,$203,$June E$.$ Arbough,Electrical Engineering,$84\mathrm{.}5,23\mathrm{.}8],[25,$Evergreen,$201,$John G$.$ News,Database Designer,$105,19\mathrm{.}4],[25,$Evergreen,$205,$Alice K$.$ Johnson,Database Designer,$105,35\mathrm{.}7],[25,$Evergreen,$206,$William Smithfield,Programmer,$50,12\mathrm{.}6],[25,$Evergreen,$202,$David Senior,System Analyst,$96\mathrm{.}75,23\mathrm{.}8],[28,$Amber Wave,$214,$Annielise Jones,Application Designer,$48\mathrm{.}1,24\mathrm{.}6],[28,$Amber Wave,$218,$James Frommer,General Support,$18\mathrm{.}36,45\mathrm{.}3],[28,$Amber Wave,$204,$Anne Ramoras,System Analyst,$96\mathrm{.}75,32\mathrm{.}4],[28,$Amber Wave,$212,$Darlene Smithson,DSS Analyst,$45,44],[32,$RollingTide,$205,$Aclice Johnson,Database Designer,$105,64\mathrm{.}7],[32,$RollingTide,$204,$Anne Ramoras,System Analyst,$96\mathrm{.}75,48\mathrm{.}4],[32,$RollingTide,$213,$Delbert Joenbrood,Application Designer,$48\mathrm{.}1,23\mathrm{.}6],[32,$RollingTide,$211,$Geoff Wabash,Clerical Support,$26\mathrm{.}87,22],[32,$RollingTide,$206,$William Smithfield,Programmer,$50,12\mathrm{.}8],[35,$Starflight,$207,$Maria Alonzo,Programmer,$50,24\mathrm{.}6],[35,$Starflight,$204,$Anne Ramoras,System Analyst,$96\mathrm{.}75,45\mathrm{.}8],[35,$Starflight,$205,$Alice K$.$ Johnson,Database Designer,$105,56\mathrm{.}3],[35,$Starflight,$214,$Annielise Jones,Application Designer,$48\mathrm{.}1,33\mathrm{.}1],[35,$Starflight,$218,$James Frommer,General Support,$18\mathrm{.}36,23\mathrm{.}6],[35,$Starflight,$212,$Darlene Smithson,DSS Analyst,$45,41\mathrm{.}3]]$

Upload a WORD file containing your NAME and the answers to the following questions about the table above.

$(12$ points$)$ What are the types of the following dependencies in the table?

ProjlD $--->$ ProjName

EmpID $-->$ EmpName, JobClass, HourlyRate

JobClass $-->$ HourlyRate

ProjlD, EmpID $-->$ Hours

$(8$ points$)$ Is this table in $1NF?$

$(10$ points$)$ What is the result of normalizing the table in $2$NF$?$

All primary keys must be marked.

All tables must be named.

All columns in each table must be listed.

$(12$ points$)$ What is the result of normalizaing the table in $3$NF$?$

All primary keys must be marked.

All tables must be named.

All columns in each table must be listed.