The table shown in Table $3$ lists dentist$/$patient appointment data. A patient is given an appointment at a

specific time and date with a dentist located at a particular surgery. On each day of patient appointments,

a dentist is allocated to a specific surgery for that day.

Table $3$: Data for Scenario $4$

Q$11$ The data shown in Table $3$ is susceptible to update anomalies. Provide examples of insertion,

deletion, and update anomalies.

Q$12$ Describe and illustrate the process of normalising the data shown in Table $3$ to $3$ NF $.$ You should

state any assumptions you make about the data shown in the table.

For example, you might assume that a patient is registered at only one surgery or a patient may

have more than one appointment on a given day.

You should show the dependency diagrams for each iteration of the normalisation process. In

other words, you should have diagrams for $1NF,2NF$ and $3$ NF