- Also known as a Partial dependency
Studentno, course —> studentName, address, city, prov, pc, grade, dateCompleted
This situation is not desirable, because every non key attribute has to be fully dependent on the PK. In this situation Student information is only ‘partially’ dependent on the PK; StudentNo.
To fix this problem, we need to break down the table into two as follows:
StudentNo, course à grade, dateCompleted
StudentNo à studentName, address, city, prov, pc