Course Solutions Uncategorized (Solved) : Normalize Given Table Functional Dependencies 1nf 2nf 3nf Bcnf Normal Forms Technician Id Q27985136 . . . .

(Solved) : Normalize Given Table Functional Dependencies 1nf 2nf 3nf Bcnf Normal Forms Technician Id Q27985136 . . . .

 

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. . . . .

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Post