An organization needs to maintain database having five attributes A, B, C, D,…

PYQ UGC NET 2019

 An organization needs to maintain database having five attributes A, B, C, D, E. These attributes are functionally dependent on each other for which functionality dependency set 𝐹𝐹 is given as: F:{A→BC,D→E,BC→D,A→D}. Consider a universal relation R(A, B, C, D, E) with functional dependency set 𝐹. Also all attributes are simple and take atomic values only.

Identify the normal form in which relation 𝑅 belong to

  1. A.

    1 NF

  2. B.

    2 NF

  3. C.

    3 NF

  4. D.

    BCNF

Attempted by 332 students.

Sign up free to check your answer

Sign up free

Explore the full course: Nta Ugc Net Paper 2

Loading lesson…