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 mothers 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

Surname	First Name	Town	Age	Child	Doctor	Date	Treatment
Smith	Jane	Coventry	30	Rebecca	Johnson	27.3.04	101
				Brian	Clarence	30.5.04	209
				Robert	Johnson	10.1.88	101
Brown	Beryl	Rugby	28	Alan	Clarence	30.4.04	214
				Sarah	Johnson	29.5.04	101
				Sarah	Clarence	12.1.04	321
Jones	Fiona	Kenilworth	34	James	Clarence	30.4.04	322
				Jenny	Clarence	11.1.04	321
				Keith	Johnson	21.4.88	409
				Simon	Clarence	11.1.04	321

1)From the functional dependencies, identify;

a)Functional dependencies

b)Partial dependencies

c)Transitive dependencies

d)Keys (primary key, Foreign key )