1.2 Exercise: Student details

A college keeps the following details about a student and the various modules the student studied:

in a relation: Student(regno, na, add, tno, tna, dc, dn, (mc, mn, res))

The functional dependencies are:

Which of the following is a normalisation of the relation Student to first normal form?
Hint: remove the repeating group.

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

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

     
  3. Student(regno, na, add, tno, tna, dc, (mc, mn, res))
    Diploma(dc, dn)

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

     

Index