Problem $5(10$ pts$)$:

Consider the following relation:

TEMP AGENCY

$\backslash$table$[[$TempID$,$TempName,JobID,Job TypelD,JobTypeDesc,EID,Ename$],[111,$Joe,J$111,$T$1,$Bookkeeppiing,E$1,$Mid Bank$],[222,$Mike,J$222,$T$2,$Answering calls,E$1,$Mid Bank$],[333,$Sue,J$333,$T$1,$Bookkeepiing,E$2,$Espoo Comm$],[444,$Pat,J$444,$T$2,$Answering calls,E$2,$Espoo Comm$],[555,$Bob,J$555,$T$1,$Bookkeepiing,E$2,$Espoo Comm$],[666,$Joe,J$666,$T$2,$Answering calls,E$1,$Mid Bank$]]$

Some of the requirements that this table is based on are as follows:

Each temporary worker has a unique TempID, and a non$-$unique TempName.

Each employer has a unique EID, and a non$-$unique EName.

Each job has a unique JobID, and a job type.

Each job type has a unique JobTypeID and a non$-$unique job type description $($JobTypeDesc$).$

Each temporary worker is assigned to only one job.

Each job has one job type, but multiple jobs can have the same job type

Each job is assigned to one employer. Same employer can have multiple jobs.

$5$a$)$ In the figure below, indicate functional dependencies by drawing lines with arrows.

TemplD

TempName

JobID

JobTypeID

JobTypeDesc

EID

Ename

$5$b$)$ Normalize the relation TEMP AGENCY to the second normal form $(2$NF$).$ Show column names $($underline primary keys$)$ and functional dependencies.

$5$c$)$ Normalize the relation TEMP AGENCY to the third normal form $(3$NF$).$ Show column names $($underline primary keys$)$ and functional dependencies.