perform UNF to 3NF normalisation

In developing your final logical data model, composite attributes present on your conceptual model must be expanded into their component simple attributes, unless otherwise directed. If the supplementary material presented in this document does not guide you in deciding the components you may make any reasonable decision on their simple component attributes. Further discussions with Monash Dental have revealed the points listed below: MD has a strict policy that patients must pay for an appointment immediately on its completion. Non private insured patients will pay 100% of the cost of the appointment. Patients who have dental insurance will have part of their account paid by the insurer 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). In developing your final logical data model, composite attributes present on your conceptual model must be expanded into their component simple attributes, unless otherwise directed. If the supplementary material presented in this document does not guide you in deciding the components you may make any reasonable decision on their simple component attributes. Further discussions with Monash Dental have revealed the points listed below: MD has a strict policy that patients must pay for an appointment immediately on its completion. Non private insured patients will pay 100% of the cost of the appointment. Patients who have dental insurance will have part of their account paid by the insurer 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)