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 namethe doctor's surname is uniquea treatment code is uniquetreatments are specific to doctors, eg 101 is only ever given by JohnsonSurnameFirst NameTownAgeChildDoctorDateTreatmentSmithJaneCoventry30RebeccaJohnson27.3.04101 BrianClarence30.5.04209 RobertJohnson10.1.88101BrownBerylRugby28AlanClarence30.4.04214 SarahJohnson29.5.04101 SarahClarence12.1.04321JonesFionaKenilworth34JamesClarence30.4.04322 JennyClarence11.1.04321 KeithJohnson21.4.88409 SimonClarence11.1.04321 From the functional dependencies, identify; Functional dependenciesPartial dependenciesTransitive dependenciesKeys (primary key, Foreign key ) Normalise to 3rd Normal form.

Answered: The following is a sample report from a…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

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

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

From the functional dependencies, identify;

Functional dependencies
Partial dependencies
Transitive dependencies
Keys (primary key, Foreign key )

Normalise to 3^rd Normal form.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions