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.

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-NonCommercial-ShareAlike 3.0 License