Partial Dependency in RDBMS

Partial Dependency in RDBMS

Partial Dependency:


If any proper subsets of the key determine any of the non-key attributes then there exist a partial dependency.

Example: Given a relation R(A,B,C,D,E) ,

Functional Dependency : AB→CDE ,

Primary_key(or simply 'key') is AB.

Then    A→C : is a Partial Dependency
            A→D :  is a Partial Dependency
            A→E : is a Partial Dependency
            B→C : is a Partial Dependency
            B→D : is a Partial Dependency
            B→E : is a Partial Dependency