Functional dependency

From Oracle FAQ
Jump to: navigation, search

A functional dependency exists when the value of one thing is fully determined by another.

For example, given the relation EMP(empNo, empName, sal), attribute empName is functionally dependent on attribute empNo. If we know empNo, we also know the empName. This is written as EmpNo->EmpName.

[edit] Also see

Glossary of Terms
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #