1.7 Exercise: Student details (continued)

Student(regno, na, add, tno, tna, dc, dn)

with functional dependencies

can be normalised to 3NF as follows.
Hint: remove the transitive dependencies.

  1. Student(regno, na, add, tno, dc, dn)
    Tutor (tno, tna)

     
  2. Student(regno, na, add, tno, dc)
    TutorDiploma (tno, dc, tna, dn)

     
  3. Student(regno, na, add, tno, dc, dn)
    Diploma (dc, dn)
    Tutor (tno, tna)

     
  4. Student(regno, na, add, tno, dc)
    Diploma (dc, dn)
    Tutor (tno, tna)

     

Index