1.8 Exercise: Student details (completed)

with functional dependencies

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

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