Normalize the given table below and functional dependencies into 1NF, 2NF, 3NF and BCNF normal forms
Technician ID | TechnicianName | 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
Reviews
There are no reviews yet.