A functional dependency X → Y means that ________.

Options

  • A. X uniquely determines Y
  • B. Y uniquely determines X in every case
  • C. X and Y must always be primary keys
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

A. X uniquely determines Y

Detailed Explanation

  • Functional dependency: X → Y means that each value of X is associated with exactly one value of Y in a relation.
  • X is called the determinant.
  • Y is functionally dependent on X.