Concepts of Database Management, 4th Edition, Pratt & Adamski
Functional
Dependence
•Column B is functionally dependent on Column A if A’s value determines a single value for B at a given time
•
•Given
A, a single value for B can be determined
e.g. A sales rep commission rate is functionally
dependent on Pay Class