Normalize the given table below and functionaldependencies into 1NF, 2NF, 3NF and BCNF normal forms
Technician ID
Technician
NameAppointment DateAppointment TimePatient IDPatient Name192115Mousa Ali12 Aug 201709:00 am21018Omar Hassan192115Mousa Ali15 Aug 201702:00 pm21020Kamal Ali192119Abdullah Haji01 Sep 201710:00 am21119Khalid Ahmed192119Abdullah Haji05 Sep 201701:00 pm21018Omar Hassan
FD1= Technician_id, app_date, app_time =>patient_id, patient_name
FD2 = Technician_id =>technician_name
FD3 = patient_id =>patient_name
Expert Answer
An answer will be send to you shortly. . . . .