[SOLVED] Normalize the given table below and functional dependencies

15.00 $

Category:

Description

5/5 - (4 votes)

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