1.7 Exercise: Student details (continued)

with functional dependencies

• dc -> dn
• tno -> tna

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