Functional dependency scope: A functional dependency (FD) is a relationship between or among which elements of a relation?

Difficulty: Easy

Correct Answer: attributes.

Explanation:


Introduction / Context:
Functional dependencies formalize how one set of attributes determines another, guiding normalization to remove redundancy and anomalies.



Given Data / Assumptions:

  • An FD is typically written X → Y.
  • X and Y are sets of attributes from the same relation schema.
  • We assume classical relational theory.


Concept / Approach:
An FD states that, for any two rows, if the X attributes match, then the Y attributes must also match. This is a constraint among attributes of a relation, not among tables or rows as entities.



Step-by-Step Solution:

Define FD: a constraint on attributes within a relation’s schema.Conclude: The relationship is among attributes, not whole tables/rows.


Verification / Alternative check:
Armstrong’s axioms and normalization proofs always reason over attribute sets.



Why Other Options Are Wrong:
Tables / relations / rows: While FDs apply to a relation schema, the relationship itself is among attributes inside that schema.
Indexes: Physical structures; unrelated to the logical constraint definition.



Common Pitfalls:
Thinking FDs are about table-to-table relationships; that is the role of referential integrity via foreign keys.



Final Answer:
attributes.

More Questions from The Relational Model and Normalization

Discussion & Comments

No comments yet. Be the first to comment!
Join Discussion