Question

Draw the diagram and post the picture or screenshot

thanks you have to do SQL diagram

AutoSave Off Normalize the below table-class Activity - Word Search MD Rashedul Islam MR File Home Insert Design Layout References Mailings Review View Help Share Comments Normalize the below table staffNo dentist Name patientNo patientName appointment surgeryNo date time S1011 P100 Gillian White S10 Tony Smith Tony Smith P105 Jill Bell S15 P108 S10 S1011 S1024 S1024 S1032 Helen Pearson Helen Pearson 12-Aug-03 10.00 13-Aug-03 12.00 12-Sept-03 10.00 14-Sept-03 10.00 14-Oct-03 16.30 15-Oct-03 18.00 P108 Ian MacKay Ian MacKay Jill Bell John Walker S10 Robin Plevin Robin Plevin P105 P110 S15 S13 S1032 INF 2NF 3NF Page 1 of 1 7 words C Focus 13 + 100% English (United States) Type here to search o O & w » C ENG 1:40 PM 2020-07-31 C 719

Answer 1

Question StaffNo DentistName PatientNo PatientName SurgeryN o S10 S15 P100 P105 S1011 S1011 S1024 S1024 S1032 S1032 P108 Tony Smith Tony Smith Helen Pearson Helen Pearson Robin Plevin Robin Plevin Appointment date time 12-Aug-03 10.00 13-Aug-03 12.00 12-Sept-03 10.00 14-Sept-03 10.00 14-Oct-03 16.30 15-Oct-03 18.00 Gillian White Jill Bell Ian Mackay Ian Mackay Jill Bell John Walker S10 S10 P108 P105 S15 P110 S13 INF ---> StaffNo S1011 S1011 S1024 DentistName PatientNo PatientName Appointment Appointment SurgeryNo time time Tony Smith P100 Gillian White 12/08/03 10:00:00 S10 Tony Smith P105 Jill Bell 13/08/03 12:00:00 S15 Helen Pearson P108 Ian Mackay 12/09/03 10:00:00 S10 Helen Pearson P108 Ian Mackay 14/09/03 10:00:00 S10 Robin Plevin P105 Jill Bell 14/10/03 16:30:00 S15 Robin Plevin P110 John Walker 15/10/03 18:00:00 S13 S1024 S1032 S1032

2NF StaffNo S1011 S1024 S1032 DentistName Tony Smith Helen Pearson Robin Plevin PatientNo PatientName P100 Appointment SurgeryNo time 10:00:00 S10 12:00:00 S15 P105 Appointment date 12/08/03 13/08/03 12/09/03 14/09/03 14/10/03 15/10/03 P108 10:00:00 Gillian White Jill Bell Ian Mackay Ian Mackay Jill Bell John Walker S10 P108 S10 P105 10:00:00 16:30:00 18:00:00 S15 P110 S13

PatientNo P100 P105 P108 PatientName Gillian White Jill Bell Ian Mackay John Walker P110 StaffNo S1011 S1011 S1024 S1032 S1032 PatientNo P100 P105 P108 P105 P110 3NF StaffNo S1011 S1024 DentistName Tony Smith Helen Pearson Robin Plevin S1032

Patient No P100 P105 P108 P110 PatientName Gillian White Jill Bell Ian Mackay John Walker PatientNo Appointment date Surgery No 12/08/03 13/08/03 S10 S15 12/09/03 P100 P105 P108 P108 P105 P110 S10 S10 14/09/03 14/10/03 15/10/03 S15 S13

StaffNo Patient No P100 S1011 S1011 S1024 S1032 S1032 P105 P108 P105 P110 Appointment time 10:00:00 12:00:00 Appointment date 12/08/03 13/08/03 12/09/03 14/09/03 14/10/03 15/10/03 10:00:00 10:00:00 16:30:00 18:00:00