Indicate which of the following statements are true: A relational database…

GATE · 1990 · CS · Question 3 subparts

Indicate which of the following statements are true: A relational database which is in 3NF may still have undesirable data redundancy because there may exist:

  1. A.

    Transitive functional dependencies

  2. B.

    Non-trivial functional dependencies involving prime attributes on the right-side.

  3. C.

    Non-trivial functional dependencies involving prime attributes only on the left-side.

  4. D.

    Non-trivial functional dependencies involving only prime attributes.

Attempted by 32 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…