The following is a sample report from a child clinic. It shows the days and treatments for visits to doctors at the clinic. A mother takes her child, sees a doctor and the doctor administers some treatment. There are couple of things you should assume:

The mother's name is unique.

a mother won't have more than one child with the same name

the doctor's surname is unique

a treatment code is unique

treatments are specific to doctors, eg $101$ is only ever given by Johnson

$\backslash$table$[[$Surname$,\backslash$table$[[$First$],[$Name$]],$Town,Age,Child,Doctor,Date,Treatment$],[$Smith$,$Jane,Coventry,$30,$Rebecca,Johnson,$27\mathrm{.}3\mathrm{.}04,101],[,,,$Brian,Clarence,$30\mathrm{.}5\mathrm{.}04,209],[,,,$Robert,Johnson,$10\mathrm{.}1\mathrm{.}88,101],[$Brown$,$Beryl,Rugby,$28,$Alan,Clarence,$30\mathrm{.}4\mathrm{.}04,214],[,,,$Sarah,Johnson,$29\mathrm{.}5\mathrm{.}04,101],[,,,$Sarah,Clarence,$12\mathrm{.}1\mathrm{.}04,321],[$Jones$,$Fiona,Kenilworth,$34,$James,Clarence,$30\mathrm{.}4\mathrm{.}04,322],[,,,$Jenny,Clarence,$11\mathrm{.}1\mathrm{.}04,321],[,,,$Keith,Johnson,$21\mathrm{.}4\mathrm{.}88,409],[,,,$Simon,Clarence,$11\mathrm{.}1\mathrm{.}04,321]]$

From the functional dependencies, identify;

a$)$ Functional dependencies

b$)$ Partial dependencies

c$)$ Transitive dependencies

d$)$ Keys $($primary key, Foreign key$)$The following is a sample report from a child clinic. It shows the days and treatments for

visits to doctors at the clinic. A mother takes her child, sees a doctor and the doctor

administers some treatment. There are couple of things you should assume:

The mother's name is unique.

a mother wor't have more than one child with the same name

the doctor's surname is unicue

a treatment code is unique

treatments are specific to doctors, eg $101$ is only ever given by Johnson

From the functional dependencies, identify;

a$)$ Funclional dependencies

b$)$ Partal dependencies

c$)$ Transitive dependencies

d$)$ Keys $($primary key, Foreign key $)$