[SOLVED] Normalize the given table below and functional dependencies

15.00 $

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

You will receive the following solution file(s) instantly after successful payment:

docx file icon Normalize.docx (17.7 KB)
Assignment Instructions Updated Recently? Submit Below and we will provide new Solution!
Submit New Instructions
đź”’ Securely Powered by:
Secure Checkout
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