E$4\mathrm{.}10$ Consider the following relation with sample data.

SURGERY SCHEDULE TABLE

$\backslash$table$[[$PatientID$,$PatientName,SurgeonID,SurgeonName,NurseID,NurseName,SurgeryDate,SurgeryType,NurseRole$],[111,$Joe,AAA,Dr$.$ Adams,N$1,$Mike,$1-$Jan,Knee Surgery,$1$st Assistant$],[111,$Joe,AAA,Dr$.$ Adams,N$2,$Sue,$1-$Jan,Knee Surgery,$1$st Assistant$],[111,$Joe,AAA,Dr$.$ Adams,N$2,$Sue,$2-$Jan,Ankle Surgery,$2$nd Assistant$],[111,$Joe,BBB$,$Dr$.$ Brown,N$2,$Sue,$3-$Jan,Elbow Surgery,$1$st Assistant$],[222,$Pat,CCC$,$Dr$.$ Crown,N$3,$Tina,$1-$Jan,Knee Surgery,$1$st Assistant$],[333,$Bob,AAA,Dr$.$ Adams,N$4,$Lee,$1-$Jan,Hip Surgery,$1$st Assistant$],[333,$Bob,AAA,Dr$.$ Adams,N$3,$Tina,$1-$Jan,Hip Surgery,$2$nd Assistant$],[333,$Bob,DDD$,$Dr$.$ Adams,N$5,$Sue,$2-$Jan,Shoulder Surgery,$1$st Assistant$],[444,$Pat,BBB$,$Dr$.$ Brown,N$6,$Pam,$1-$Jan,Hip Surgery,$1$st Assistant$]]$

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 day.

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.

E$4\mathrm{.}10$a Depict full key functional dependencies, partial functional dependencies $($if any$),$ and transitive functional dependencies $($if any$)$ in the Surgery Schedule Table.

E$4\mathrm{.}10$b Show the result of normalizing the Surgery Schedule Table to $2$NF$.$

E$4\mathrm{.}10$c Show the result of normalizing the Surgery Schedule Table to $3$NF$.$

Please upload pictures of tables