Machine-translated by Google. Questions are authored in English.
Top

Discussion

In 2NF

  • A.No functional dependencies (FDs) exist.
  • B.No multivalued dependencies (MVDs) exist.
  • C.No partial FDs exist.
  • D.No partial MVDs exist.

Answer: C

Correct answer: No partial FDs exist.

Second normal form requires that every non-key attribute depend on the whole of the primary key, so a dependency on only part of a composite key - a partial functional dependency - is what 2NF eliminates. Transitive dependencies are left to 3NF.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.