Answer to Problem 3.4
The original relation is
student id —> [ssn, name]
There is a conditional dependency student id - -> ssn. Create another relation with these two attributes and drop ssn from the original relation. Now we have the following:
student id —> name
student id - -> ssn
Return to conditional dependencies.
page revision: 2, last edited: 11 Aug 2008 23:50