A relation is in Second Normal Form (2NF) if it is in 1NF and has no ________.

Options

  • A. Transitive dependency
  • B. Partial dependency
  • C. Multivalued dependency
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

B. Partial dependency

Detailed Explanation

  • 2NF: A relation must first satisfy 1NF.
  • It must have no partial dependency of a non-prime attribute on a candidate key.
  • Partial dependency occurs when a non-key attribute depends on only part of a composite candidate key.