4
5
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