![[Solved] Normalize the given table below and functional dependencies](https://assignmentchef.com/wp-content/uploads/2022/08/downloadzip.jpg)
Normalize the given table below and functional dependencies into 1NF, 2NF, 3NF and BCNF normal forms
| Technician ID | TechnicianName | 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
![[Solved] Database Systems Project 2: Using PL/SQL and JDBC to Implement Student Registration System](https://assignmentchef.com/wp-content/uploads/2022/08/downloadzip-1200x1200.jpg)
Reviews
There are no reviews yet.