In a schema R(A, B, C, D, E, F, G, H), each field of R contains only atomic…

PYQ UGC NET 2024

In a schema R(A, B, C, D, E, F, G, H), each field of R contains only atomic values. F = {CH→G, A→BC, B→CFH, E→A, F→EG} is a set of functional dependencies so that F+ is exactly the set of FDs that holds R. The relation R is :

  1. A.

    In 1NF, but not in 2NF

  2. B.

    In 2NF, but not in 3NF

  3. C.

    In 3NF, but not in BCNF

  4. D.

    In BCNF

Attempted by 428 students.

Sign up free to check your answer

Sign up free

Explore the full course: Nta Ugc Net Paper 2

Loading lesson…