$$ NORMALIZATION

$($Apply the normalization process to the model.$)$

$$ FUNCTIONAL DEPENDENCIES

$($Below is an example showing the functional dependencies, you should do your own project.$)$

$($The following is the set of functional dependencies $($FD$\text{'}$s$)$ of COMPANY.$)$

F $=\{$ FD$1$: SSN $->$ FNAME, MINIT, LNAME, SSN$,$ BDATE, ADDRESS, SEX,

SALARY, SUPERSSN, DNO, HIREDDATE, TERMINATEDATE

FD$2$: DNUMBER $->$ DNAME, DNUMBER, MGRSSN$,$ MGRSTARTDATE

FD$3$: DNAME $->$ DNAME, DNUMBER, MGRSSN$,$ MGRSTARTDATE

FD$4$: PNUMBER $->$ PNAME, PNUMBER, PLOCATION, DNUM, BUDGETEDHOURS

FD$5$: PNAME $->$ PNAME, PNUMBER, PLOCATION, DNUM, BUDGETEDHOURS

FD$6$: DNUMBER, DLOCATION $->$ DNUMBER, DLOCATION

FD$7$: ESSN, PNO $->$ ESSN, PNO, HOURSSPENT

FD$8$: ESSN, DEPENDENT$\_$NAME $->$ ESSN, DEPENDENT$\_$NAME, SEX$($dependent$),$ BDATE$($dependent$),$ RELATIONSHIP $\}$

$$ UNNORMALISED FORM

$$ FIRST NORMAL FORM

$$ SECOND NORMAL FORM

$$ THIRD NORMAL FORM