///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

Use the provided information to answer the following question.

Please provide a 3NF dependency diagram, followed by an ERD

Happy Smile Dentistry Assignment The table below list a sample dentist patient appointment data. A patient is given an specific time and date with a dentist to perform a particular surgery. On each day of patient appoint is allocated to specific surgery for that day. appointment, at a The table shown in the table below is susceptible to update anomalies. Provide examples of insertion, deletion, and update anomalies (a) Describe and illustrate the process of normalizing the table shown in the table to 3NF State any assumptions you make about the data shown in this table. (b) Describe and illustrate the process of normalizing the tables in the figure below to 3NF relations. Develop an ERD that shows primary keys. Convert the ERD into a logical model that shows both primary keys and foreign keys. (c) Staff Dentist .Name PatientPatient Appointment Appointment Surgery Surgery No Number Name S1011 Tony SmithP100Sue Ray Jill Bell P108 Sue Ray P108 Sue Ray Jill Bell Date 12-9-14 12-9-14 12-9-14 12-14-14 12-14-14 12-15-14 Time 10.00 12.00 10.00 14.00 30 Code S15 Name Root Root Crown Crown Root Bridge S1011 Tony Smith S1024Pam Jones S1024 P105 S10 Pam Jones S1052 Joe Robin S1052Joe Robin S1053 Joe Johnson P110 P115 Norm Smith 12-15-14 Rob Terry S13 S11 Extraction 18:30