Normalizaiton of dentist-patient appointment data 1NF, 2NF and 3NF
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.
via email: mhassnainjamil@gmail.com
via WhatsApp: +92-324-7042178
via skype: hassnainjamil1
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.
StaffNo | Dentist Name | PatNo | PatName | Appointment Date & Time | SurgeryNo |
S1011 S1011 S1024 S1024 S1032 S1032 | James Bond James Bond Andrew Joe Andrew Joe Kevin King Kevin King | P100 P105 P108 P108 P107 P110 | Kim Su Jenny Gold Ian Chappell Ian Chappell John Spooner Frank Holey | 1/9/05 10.00 1/9/05 12.00 1/9/05 10.00 2/7/05 14.00 2/7/05 16.30 2/7/05 18.00 | S10 S15 S10 S10 S15 S13 |
- 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
CONTACT DETAILS
For any other questions or other tasks please feel free to contact mevia email: mhassnainjamil@gmail.com
via WhatsApp: +92-324-7042178
via skype: hassnainjamil1
Comments
Post a Comment