Question $3($Marks: $40)$

Q$\mathrm{.}3\mathrm{.}1$ What is the objective of the normalisation process? $(6)$

Q$\mathrm{.}3\mathrm{.}2$ When is a table in second normal form $(2$NF$)?(2)$

Q$\mathrm{.}3\mathrm{.}3$ When is a table in third normal form $(3$NF$)?(2)\backslash$