Partial functional dependency / What is partial functional dependency / Why it is called as partial functional dependency? / Define partial functional dependency
Partial Functional Dependency
Partial Dependency is a form of Functional dependency that holds on a set of attributes. It is about the complete dependency of a right hand side attribute on one of the left hand side attributes.
For example, in a functional dependency PQ → R, if either P alone or Q alone can uniquely identify R, then this is said to be Partial Functional Dependency. We read this as R is partially functionally dependent on P or R is partially functionally dependent on Q.