1) The table shown in Figure 1 lists dentist/patient appointment data. A patient

1)
The table shown in
Figure 1 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. (5 Marks)staffNodentistNamepatNopatNameappointment date timesurgeryNoS1011Tony SmithP100Gillian White12-Sept-13
10:00S15S1011Tony SmithP105Jill Bell12-Sept-13
12:00S15S1024Helen PearsonP108Ian MacKay12-Sept-13
10:00S10S1024Helen PearsonP108Ian MacKay14-Sept-13 14:00S10S1032Robin PlevinP105Jill Bell12-Sept-13 16:30S15S1032Robin PlevinP110John Walker15-Sept-13 18:00S13(a)
Describe and illustrate
the process of normalizing the table shown in Figure 1 to 3NF.