E4.10 Consider the following relation with sample data SURGERY SCHEDULE TABLE PatientID PatientName SurgeonID SurgeonName NurselD NurseName SurgeryDate SurgeryType Nu N1 N2 N2 N2 N3 N4. N3 N5 N6 NurseRole Dr. Adams Dr. Adams Dr. Adams Dr. Brown Dr. Crown Dr. Adam:s Dr. Adams Dr. Adams Dr. Brown Mike Knee Surgery 1-Jan 1-Jan 2-Jan 3-Jan 1-Jan 1-Jan 1-Jan 2-Jan 1-Jan st Assistant Knee Surgery 2nd Assistant kle Surgery 1st Assistant 1st Assistant 1st Assistant 1st Assistant 2nd Assistant Shoulder Surgery 1st Assistant 1st Assistant ue Sue Pat Bob Bob Bob Pat Elbow Surgery Knee Surgery Hip Surger Hip Surgery Tina ue Hip Surgery .The SURGERY SCHEDULE Table captures the data about scheduled surgeries. .Each patient has a unique Patient ID and a Patient Name. .Each surgeon has a unique Surgeon ID and a Surgeon Name. Each nurse has a unique Nurse ID and a Nurse Name. Each scheduled surgery is of one particular type. Each patient can have multiple surgeries scheduled, but only one surgery per .During one surgery, one surgeon works on one patient assisted by one or more nurses .During each surgery, each nurse has one particular role. A nurse does not have to have the same role in each surgery that she or he participates in .Surgeons and nurses can participate in more than one surgery per day. E4.10a Depict full key functional dependencies, partial functional dependencies (if any), and transitive functional dependencies (if any) in the SURGERY SCHEDULE Table E4.10b Show the result of normalizing the SURGERY SCHEDULE Table to 2NF