1.8 Exercise: Student details (completed)

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

with functional dependencies

is normalised into 3NF using the following 5 relations:

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

Index