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)$

Consider the table in first normal form $(1$NF$)$ below, then answer Questions $3\mathrm{.}4$ and $3\mathrm{.}5.$

Database name: Photographer$\_$Photos

Table name: DATA$\_$ORG$\_1$NF

PHOTOGRAPHER

ID

PHOTOGRAPHER

NAME & SURNAME

PHOTO

ID

PHOTO

DESCRIPTION

GENRE

ID

GENRE

DESCRIPTION

A$001$ Thabo Ndlovu B$001$ Lion$$s Pride C$001$ Wildlife

A$002$ Clark Grobler B$002$ Prada Proud C$002$ Fashion

A$003$ Sbonelo Mthaba B$003$ Flower Arrangement C$004$ Still Life Photos

A$004$ Teagan Boland B$004$ Rush Hour Traffic C$003$ Street Photos

A$001$ Thabo Ndlovu B$005$ Taking Flight C$001$ Wildlife

A$003$ Sbonelo Mthaba B$006$ Worker Protests C$005$ Photojournalism

A$002$ Clark Grobler B$007$ Oakley Summer $2023$ C$002$ Fashion

A$001$ Thabo Ndlovu B$008$ Farm Life C$001$ Wildlife

A$002$ Clark Grobler B$009$ Antique Chair C$004$ Still Life Photos

Q$\mathrm{.}3\mathrm{.}4$ Normalise the table presented above to second normal form $(2$NF$),$ showing all

steps with explanations. All steps and the final answer must be in dependency

diagram format.

$(15)$

Q$\mathrm{.}3\mathrm{.}5$ Once you have answered Question $3\mathrm{.}4,$ extend your answer to normalise the

table above to the third normal form $(3$NF$),$ showing all steps with explanations.

All steps and the final answer must be in dependency diagram format