Normalize the given table below and functional dependencies Solved

15.00 $

Category:
Click Category Button to View Your Next Assignment | Homework

You'll get a download link with a: . docx solution files instantly, after Payment

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

  • Normalize.docx