Ex 4.10 a, b, c

124 Part 1 Operational Databases 10b Show the result of normalizing the SUR E4. E4.10a Depict full key functional dependencies, partial SURGER functional dependencies (if any), and transitive functional dependencies (if any) in the SURGERY SCHEDULE Table. SCHEDULE Table to 2M-"- Show the result of normalizing the SURGER FA.10c SCHEDULE Table to 3N EA10 Consider the following relation with sample data. SURGERY SCHEDULE TABLE PatientiD PatientName SurgeonlD SurgeonName NurselD NurseName SurgeryDate SurgeryTypeNurseRole Knee Surgery Dr. Adams Dr. Adams N2 Dr. Adams Dr. Brown Mike Sue Sue Sue 1-Jan 1-Jan 2-Jan 3-Jan oe Knee Surgery 2nd Assistant Ankle Surgery 1st Assistant Elbow Surgery st Assistant N2 N2 Pat Bob Bob Bob CCC Dr.own N3 Tina1-Jan Knee Surgery1st Assistant AAA N3 Tina-11-Jan Hip Surgery 2nd Assistant 1-Jan Hip Surgery 1st Assistant Dr. Adams Dr. Adams Dr. Adams Dr. Brown 2-JanShoulder Surgery 1st Assistant 1-Jan Hip Surgery 1st Assistant Sue Pam N5 . The StUR