$($Total $15$ points$)$ Based on this employee and on$-$going project contract report, create

database ER Diagram, Relational Tables, & Relational Schema

We assume that SSN represents the Social Security Number or an equivalent universal

identifier, while empID is a unique identifier assigned within the company. Additionally, we

assume that each employee may be assigned to multiple projects simultaneously. The

$"$Hr$/$W$"$ field records the number of hours an employee is allocated to a specific project per week, and "Rating" reflects the employee's performance rating for that project. Each project has a single director $($projDir$),$ a unique name, a budget, and multiple employees working on it$.$ While project names are unique, the names of employees are not.$(1)$

$(1$ point$)$ Please make this business form in a single DB table based on the $1$NF$.$

$(2)(7$ points$)$ Please specify partial, full key, and transitive functional dependencies.

$(3)(2$ points$)$ Please normalize the table$($s$)$ according to the $2$NF$.$

$(4)(2$ points$)$ Please normalize the table$($s$)$ according to the $3$NF$.$

$(5)(3$ points$)$ Please complete your ER Diagram, Relational Tables, & Relational

Schema.

Please attach drawings if possible. Will upvote $\backslash$table$[[$empID$,$SSN$,$Name,deptID,Mgr$,$JobTit,Rating,projID,projName,projDir,Bgt$,$Salary,Hr$/$W$],[101,$X$334,$Adams,$10,$Munez,Programmer,$4,$J$10,$Atlantic,Quinn,$100$ K$,45$ K$,20],[101,$X$334,$Adams,$10,$Munez,Programmer,$5,$J$25,$Pacific,Ryan,$200$ K$,45$ K$,10],[102,$X$890,$Burns,$12,$Nolan,DBA,$4,$J$10,$Atlantic,Quinn,$100$ K$,60$ K$,30],[103,$X$344,$Cabot,$11,$Peyton,DBA,$3,$J$30,$Aretic,Smith,$200$ K$,60$ K$,10],[104,$X$778,$Adams,$12,$Nolan,Programmer,$3,$J$25,$Pacific,Ryan,$200$ K$,50$ K$,15]]$