Perform normalisation to 3NF for the data depicted in the sample documents. Note that only one normalisation is required for the function room evaluation, you have been provided with two samples so you can appreciate some of the variety which occurs.

PLS HELP IN 3NF NORMALISATION URGENT THANKS

Monash Dental have provided several forms, depicted below, which they make use of, showing some of the data they wish to record: . a sample 'Daily Provider Running Sheet' which shows appointments for a specific dentist on a particular day (Figure A), and two sample 'Appointment Completion' reports (Figures B1 and B2). . MONASH DENTAL DAILY PROVIDER RUNNING SHEET Report Date: 10/01/2021 Provider Code: XIL002 Provider Name: Dr Jane Xilu Provider Registration Number: DEN10242 Provider First Registered Date: 25 September 2007 Provider Registration Status: Registered Suspended Cancelled Provider Month to Date Total Charge: $2528 Provider Year to Date Total Charge: $2528 Appointment Date Time Patient Number Patient Name 10/01/2021 9:15 852 Jack Wilsons 10/01/2021 9:45 924 Lily Wu 10/01/2021 10:30 1001 Mary Wilhelm 10/01/2021 11:30 1013 Kate Hills 10/01/2021 14:15 998 William Kohl Figure A MONASH DENTAL APPOINTMENT COMPLETION REPORT - Sample 1 Patient Number: 1001 Patient Name: Mary Wilhelm Appointment: Date: 10th January 2021 Time: 10:30 AM Provider Code: XIL002 Provider Name: Dr Jane Xilu Appointment Location (Room): 8 Appointment Type: Long Service Code Description Standard Fee Fee Charged 9875 Check up 54.85 54.85 2348 Extraction 134.08 165.00 1207 Filling 109.70 145.60 1091 Scale and Clean 86.50 86.50 Total Appointment Cost $451.95 APPOINTMENT PAYMENT: Payment No Payment From Amount Paid 123456 Insurer $205.00 123457 Patient $246.95 Figure B1 MONASH DENTAL APPOINTMENT COMPLETION REPORT - Sample 2 Patient Number: 1002 Patient Name: Peter Green Appointment: Date: 10th January 2021 Time: 10:30 AM Provider Code: WUM001 Provider Name: Dr Mary Wu Appointment Location (Room): 6 Appointment Type: Short Service Code Description Standard Fee Fee Charged 9875 Check up 54.85 54.85 Total Appointment Cost $54.85 APPOINTMENT PAYMENT: Payment No Payment From Amount Paid 123612 Patient $54.85 Figure B2 REMEMBER you must keep up to date with the Ed Assignment 1B forum where further clarifications may be posted (this forum is to be treated as your client). Monash Dental have provided several forms, depicted below, which they make use of, showing some of the data they wish to record: . a sample 'Daily Provider Running Sheet' which shows appointments for a specific dentist on a particular day (Figure A), and two sample 'Appointment Completion' reports (Figures B1 and B2). . MONASH DENTAL DAILY PROVIDER RUNNING SHEET Report Date: 10/01/2021 Provider Code: XIL002 Provider Name: Dr Jane Xilu Provider Registration Number: DEN10242 Provider First Registered Date: 25 September 2007 Provider Registration Status: Registered Suspended Cancelled Provider Month to Date Total Charge: $2528 Provider Year to Date Total Charge: $2528 Appointment Date Time Patient Number Patient Name 10/01/2021 9:15 852 Jack Wilsons 10/01/2021 9:45 924 Lily Wu 10/01/2021 10:30 1001 Mary Wilhelm 10/01/2021 11:30 1013 Kate Hills 10/01/2021 14:15 998 William Kohl Figure A MONASH DENTAL APPOINTMENT COMPLETION REPORT - Sample 1 Patient Number: 1001 Patient Name: Mary Wilhelm Appointment: Date: 10th January 2021 Time: 10:30 AM Provider Code: XIL002 Provider Name: Dr Jane Xilu Appointment Location (Room): 8 Appointment Type: Long Service Code Description Standard Fee Fee Charged 9875 Check up 54.85 54.85 2348 Extraction 134.08 165.00 1207 Filling 109.70 145.60 1091 Scale and Clean 86.50 86.50 Total Appointment Cost $451.95 APPOINTMENT PAYMENT: Payment No Payment From Amount Paid 123456 Insurer $205.00 123457 Patient $246.95 Figure B1 MONASH DENTAL APPOINTMENT COMPLETION REPORT - Sample 2 Patient Number: 1002 Patient Name: Peter Green Appointment: Date: 10th January 2021 Time: 10:30 AM Provider Code: WUM001 Provider Name: Dr Mary Wu Appointment Location (Room): 6 Appointment Type: Short Service Code Description Standard Fee Fee Charged 9875 Check up 54.85 54.85 Total Appointment Cost $54.85 APPOINTMENT PAYMENT: Payment No Payment From Amount Paid 123612 Patient $54.85 Figure B2 REMEMBER you must keep up to date with the Ed Assignment 1B forum where further clarifications may be posted (this forum is to be treated as your client)