Question $2$

Answer this question in your answer script.

A spreadsheet already contains a lot of data about pharmacies and the pharmacists who work in them. An extract from the spreadsheet is shown below. The data has already been normalised to the first normal form.

Consider the table in first normal form $(1$NF$)$ below, and then answer questions $2\mathrm{.}1$ and $2\mathrm{.}2.$

PharmacyName

GroupID

GroupName

PharmacistID

PharmacistName

$1$

Dischem Sandton

$1$

Dischem

$3$

Thandi Siko

$2$

Dischem Soweto

$1$

Dischem

$9$

Jake Oliver

$3$

Fourways Klinicare

$2$

Klinicare

$2$

Steve da Costa

$4$

Clicks Sandton City

$3$

Clicks

$4$

John Makalima

$5$

Clicks Soweto

$3$

Clicks

$8$

Jane Makalima

$6$

Clicks Montecasino

$4$

Clicks

$7$

Steve van Rooyen

LED

$7$

Randburg Pharmacare

$5$

Pharmacare

$1$

Sarah Coetzee

$8$

Fourways Pharmacare

$5$

Pharmacare

$5$

Bongi Mbete

Q$\mathrm{.}2\mathrm{.}1$

Normalise the table presented to the second normal form $(2$NF$),$ showing all

steps with explanations. All steps, as well as the final answer, must be in dependency diagram format.

Q$\mathrm{.}2\mathrm{.}2$

Once you have answered Question $2\mathrm{.}1,$ extend your answer to normalise to the third normal form $(3$NF$),$ showing all steps with explanations. All steps, as well as the final answer, must be in dependency diagram format.