# $14.(10$ points$)$

Convert the below ERD to a logical model using relational schema$/$model$.$

You must indicate primary key for each schema.

You must include all the attributes within each schema.

You must indicate FKs at this stage.

$$

$$

$$

$$

$$

$$

$$

$$

$$

$$

$$

$$

Your answers for relational schema: Irvine Agency supplies part$-$time$/$temporary staffs to hotels within Irvine. The table shown below lists the time spent by agency staffs working at various hotels. The staffald is unique for every member of staff. Note that these instances are only partial records of all the instances.

Functional Dependencies provided:

$($Staffoal Contract Num$)\backslash (\backslash$rightarrow $\backslash )$ Hours

Staffaad $\backslash (\backslash$rightarrow $\backslash )$ Staffactame

Contract Num $\backslash (\backslash$rightarrow $\backslash )$ Hotela Num, Hotel Location

Hotel Num $\backslash (\backslash$rightarrow $\backslash )$ Hotel Loacation

The following relational schema corresponds to the table above. Underlined attributes are PKs: STAFF $($StaffID$,$ Staffa$$tame$,$ Contract Num, Hours, HotelaNum, Hotel Location$)$

For the relation:

$($i$)$ Identify whether the relation needs to be normalized or not $($answer either Yes or No$).$

$($ii$)$ State the reason why it needs to be normalized. You should provide all the non$-$full functional dependencies that cause the relation to be in that normal form $($this only applies when a relation is in the $1$ NF or the $2$ NF $).$

$($iii$)$ Convert the relation into the $3$NF if necessary $($if not, write down 'conversion is not needed'$).$

$($iv$)$ If you have converted the relation to $3$ NF $,$ identify PK $($s$)$ and $\backslash (\backslash$mathrm$\{$FK$\}(\backslash$mathrm$\{$s$\})\backslash )$ in each relation.