Consider the following relational schema along with all the functional…

PYQ GATE 2025

Consider the following relational schema along with all the functional dependencies that hold on them.

R1(A,B,C,D,E):𝐷→𝐸,𝐸𝐴→𝐵,𝐸𝐵→𝐶R1(A, B, C, D, E): { 𝐷 → 𝐸, 𝐸𝐴 → 𝐵, 𝐸𝐵 → 𝐶} \\

R2(A,B,C,D):𝐴→𝐷,𝐴→𝐵,𝐶→𝐴R2(A, B, C, D): { 𝐴 → 𝐷, 𝐴 → 𝐵, 𝐶 → 𝐴}

Which of the following statement(s) is/are TRUE?

  1. A.

    R1R1 is in 3NF

  2. B.

    R2R2 is in 3NF

  3. C.

    R1R1 is NOT in 3NF

  4. D.

    R2R2 is NOT in 3NF

Attempted by 389 students.

Sign up free to check your answer

Sign up free

Explore the full course: Zero To Hero

Loading lesson…