1.4 Exercise: Student details (continued)

Student(regno, na, add, tno, tna, dc, dn)
Module(regno, mc, mn, res)

The functional dependencies are still:

• dc -> dn
• tno -> tna
• regno, mc -> res
• mc -> mn

Which of the following is a normalisation of the relations Student and Module to second normal form?
Hint: check for partial key dependencies.

1. Student(regno, na, add, tno, tna, dc)
   Diploma(dc, dn)
   Module(regno, mc, mn, res)
    
2. Student(regno, na, add, tno, dc, dn)
   Tutor(tno, tna)
   Module(regno, mc, mn, res)
    
3. Student(regno, na, add, tno, tna, dc, dn)
   Module(mc, mn)
   Result (regno, mc, res)
    
4. Student(regno, na, add, tno, tna, dc, dn)
   Module(mc, mn)
   Result (regno, res)
    

Index