2NF DBMS Partial Dependency


The number of partial dependencies in a relation R{X,Y,V,U,Z} with FD set F={X->YZ, Z->V, V->XY} is ____


Candidate keys = { XU, VU, ZU }

So, Prime Attributes = { X, U, V, Z }
Non-Prime Attributes = { Y }

Partial dependency means that a non prime attribute is functionally dependent on part of a candidate key.

So from the given functional dependencies ,
X->Y and V->Y are the two partial dependencies.

So, answer is 2.