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

SURGERY SCHEDULE TABLE

BiticadD

PatientName SurgeolD SurgeonName SiurselD NurseName Surzery Date

Surgery Type

$$

De$.$ Adams

Mike

$1-$Jam

Kace Surgery

$$

Dr$.$ Adams

N$2$

Suc

$1-$Jan

Kace Surgery

Ist Assistant

AAA

Suc

$2-$Jam

Askle Surgery

N$2$

Elbow Surgery

$222$

Dr$.$ Crown

N$3$

Tina

$1-$Jam

Knee Surgery

Ist Assistant

Bob

AAA

Dr$.$ Adams

Lee

$1-$Jan

Hip Sargery

Ist Assistant

N$3$

Hip Surgery

$333$

$$

DDD

De$.$ Adams

NS

Suc

$2-$Jam

Shoulder Surgery

Ist Assistant

BBB

De$.$ Brows

Pam

$1-$Jan

Hip Surgery

$1$st Assistane

$*$ The SURGERY SCHEDULE Table captures the data about scheduled surgeries.

$*$ Esch 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.

$*$ Esch 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 paticnt 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 Schodule Table to $2$NF$.$

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