Database System Concepts
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
Bartleby Related Questions Icon

Related questions

Question
  1. 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;

 

  1. Functional dependencies
  2. Partial dependencies
  3. Transitive dependencies
  4. Keys (primary key, Foreign key )

 

  1. Normalise to 3rd Normal form.
Expert Solution
Check Mark
Knowledge Booster
Background pattern image
Computer Science
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
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education