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

PYQ UGC NET 2019

 An organization needs to maintain database having five attributes A,B,C,D,EA, 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}F:\{A→BC,D→E,BC→D,A→D\}. Consider a universal relation R(A,B,C,D,E)R(A, B, C, D, E) with functional dependency set 𝐹𝐹. Also all attributes are simple and take atomic values only.

Assume that given table R is decomposed in two tables

R1(A,B,C)R_1(A, B, C) with functional dependency set f1={A→B,A→C}f_1=\{A→B,A→C\} and 

R2(A,D,E)R_2(A, D, E) with FD set F2={A→D,D→E}F_2=\{A→D,D→E\}

Which of the following option is true w.r.t. given decomposition?

  1. A.

    Dependency preservation property is followed

  2. B.

    𝑅1𝑅_1 and 𝑅2𝑅_2 are both in 2 𝑁𝐹2 𝑁𝐹

  3. C.

    𝑅2𝑅_2 is in 2NF2 NF and 𝑅3𝑅_3 is in 3 𝑁𝐹3 𝑁𝐹

  4. D.

    𝑅1𝑅_1 is in 3 𝑁𝐹3 𝑁𝐹 and 𝑅2𝑅_2 is in 2NF2 NF

Attempted by 266 students.

Sign up free to check your answer

Sign up free

Explore the full course: Nta Ugc Net Paper 2

Loading lesson…