The table shown below lists dentist-patient appointment

Question

Question 1: The table shown below 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.
StaffNo Dentist Name PatNo PatName Appointment Date & Time SurgeryNo
S1011
S1011
S1024
S1024
S1032
S1032 James Bond
James Bond
Andrew Joe
Andrew Joe
Kevin King
Kevin King P100
P105
P108
P108
P107
P110 Kim Su
Jenny Gold
Ian Chappell
Ian Chappell
John Spooner
Frank Holey 1/9/05 10.00
1/9/05 12.00
1/9/05 10.00
2/7/05 14.00
2/7/05 16.30
2/7/05 18.00 S10
S15
S10
S10
S15

S13

2. Evaluate if the table shown above is normalized, if not describe and illustrate the process of normalizing the table shown above to third normal form. State any assumptions you make about the data shown in this table. (15 Points)

Answer 1

I just need the answer of the first question. The table illustrated in the problem lists dentist-patient appointment data. A patient is provided an appointment at a particular time and date by a dentist situated at a specific surgery. On each day of patient appointments, a dentist is assigned to a particular surgery for that day.