What is a partial functional dependency in database normalization?

Options

  • A. A non-prime attribute depends on only a proper subset of a candidate key
  • B. An attribute depends on the entire candidate key
  • C. A key depends on a non-key attribute
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

A. A non-prime attribute depends on only a proper subset of a candidate key

Detailed Explanation

Explanation: Partial dependency occurs when a non-prime attribute depends on only part of a composite candidate key. 2NF eliminates this dependency.
← Previous Next →

Attempt Quiz Now:

TRE 4.0 DBMS Quiz Practice Set 1

Feature Posts