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 ____

# 2NF DBMS Partial Dependency

**Ruturaj**#2

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.