Question $2$

$($Marks: $20)$

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

$\backslash$table$[[\backslash$table$[[5^5$