Normalize the given table below and functional dependencies

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
Powered by