5.1 Exercise: GP Database

Normalise the following relation to 3NF showing all the steps involved.
GP(gpno,cpname,gpadd,(patno,patname,patadd,patdob,(apptdate,apptime,diagnosis,treatment)))
  gpno -> gpname,gpadd
  patno -> patname,patadd, patdob
  patno,apptdate -> apptime,diagnosis
  diagnosis -> treatment

Copy the relation into a text editor and normalise it. When you are finished ask a lecturer or demonstrator to check your result.

  Next

Index