Description
Normalize the given table below and functional dependencies into 1NF, 2NF, 3NF and BCNF normal forms
Technician ID | Technician
Name |
Appointment Date | Appointment Time | Patient ID | Patient Name |
192115 | Mousa Ali | 12 Aug 2017 | 09:00 am | 21018 | Omar Hassan |
192115 | Mousa Ali | 15 Aug 2017 | 02:00 pm | 21020 | Kamal Ali |
192119 | Abdullah Haji | 01 Sep 2017 | 10:00 am | 21119 | Khalid Ahmed |
192119 | Abdullah Haji | 05 Sep 2017 | 01:00 pm | 21018 | Omar Hassan |
FD1= Technician_id, app_date, app_time =>Â patient_id, patient_name
FD2 = Technician_id =>Â technician_name
FD3 = patient_id =>Â patient_name