First page Back Continue Last page Graphics
Solution:
Use the fd {tnr} {coursensme} in the “teaches” relation to decompose that. Result:
- teacher(tnr, tname, nb-hours)
- qualification(tnr, coursename, grade)
- program(grade, coursename, nb-hours)
- teaches_1(tnr, coursename) teaches_2(tnr, grade)
We do not need to use the mvd {tnr} {coursename} in the relation “qualification” to obtain
- qualification_1(tnr, coursename) qualification_2(tnr, grade)
- because using the mvd results in 4NF and only BCNF was required.
Notes: