Consider the following relational schema along with all the functional…

GATE · 2025 · CS · Set 2 · Computer Science & IT

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 346 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…