1.6 Exercise: Student details (continued)

The result for 2NF is:

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

Which of these three relations needs to be normalised further to reach 3NF?

  1. Module needs to be normalised further.
     
  2. Result needs to be normalised further.
     
  3. Student needs to be normalised further.
     
  4. All relations are in 3NF. Nothing else needs to be done.
     

Index