Consider a relation scheme R = (A, B, C, D, E, H) on which the following…

Consider a relation scheme R = (A, B, C, D, E, H) on which the following functional dependencies hold: {A–>B, BC–>D, E–>C, D–>A}. Which one of the following is TRUE about the above schema?

  1. A.

    The schema is in 3NF but not in BCNF

  2. B.

    The schema is in BCNF

  3. C.

    The schema is not in 2NF

  4. D.

    The schema is in 2NF but not in 3NF

Attempted by 141 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…