Multiple choice

A relational database, which is in 3NF, may have undesirable data redundancy because there may exist

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

  2. non -trivial functional dependencies involving only prime attributes

  3. either (1) or (2)

  4. both (1) and (2)
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Third Normal Form (3NF) only eliminates transitive dependencies where non-prime attributes depend on other non-prime attributes. Functional dependencies involving prime attributes (either as determinant or dependent) can still exist and cause data redundancy even in 3NF relations.

Keep practicing — related questions