1.2 Exercise: Student details
A college keeps the following details about a student and the various
modules the student studied:
- regno - registration number
- na - student name
- add - student address
- tno - tutor number
- tna - tutor name
- dc - diploma code
- dn - diploma name
- mc - module code
- mn - module name
- res - module exam result
in a relation: Student(regno, na, add, tno, tna, dc, dn, (mc, mn, res))
The functional dependencies are:
- dc -> dn
- tno -> tna
- regno, mc -> res
- mc -> mn
Which of the following is a normalisation of
the relation Student to first normal form?
Hint: remove the repeating group.
- Student(regno, na, add, tno, tna, dc, dn)
Module(regno, mc, mn, res)
- Student(regno, na, add, tno, tna, dc, dn, (mc, res))
Module(mc, mn)
- Student(regno, na, add, tno, tna, dc, (mc, mn, res))
Diploma(dc, dn)
- Student(regno, na, add, tno, tna, dc)
Module(regno, mc, mn, res)
Diploma(dc, dn)
Index