Consider the following relation R(P, Q, X, Y, Z) and functional dependencies F…

Consider the following relation R(P, Q, X, Y, Z) and functional dependencies F that hold over this relation.

P, Q, Y → X

Q, X → Y

X, Y → Z

In which normal form is relation R? (Recall that a relation can be in multiple normal forms)

  1. A.

    2NF

  2. B.

    1NF

  3. C.

    3NF

  4. D.

    BCNF

Attempted by 54 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…