The table shown below lists dentist-patient appointment data. A patient is given an appointment at a specific time and date with a dentist. On each day of patient appointments, a dentist will perform specific surgery (such as Implant S10, Root Canal S15) for that day.
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. (20 Points)
- Is the table in 1NF, 2NF, or 3NF?
- If not, describe and illustrate the process of normalizing it to 3NF.
- Show final tables with data after normalization.