Functional dependency terminology: in the dependency R → S, is R properly called the determinant?

Difficulty: Easy

Correct Answer: Correct

Explanation:


Introduction / Context:
Functional dependencies (FDs) describe how attribute sets constrain each other. The left-hand side (LHS) of an FD determines the values on the right-hand side (RHS). This question checks your recall of the standard term for the LHS.



Given Data / Assumptions:

  • FD written as R → S, where R and S are sets of attributes.
  • By definition, R functionally determines S.
  • Minimality is not assumed unless specifically stated (e.g., candidate keys).


Concept / Approach:
The LHS of an FD is called the determinant because its values uniquely determine the RHS within a given relation state. Whether R is minimal (i.e., no proper subset determines S) is a separate property; minimal determinants correspond to candidate keys when RHS includes all attributes in the relation.



Step-by-Step Solution:

Interpret R → S as “for any two tuples agreeing on R, they must also agree on S.”Name the LHS (R) as the determinant because it determines S.Conclude that the statement is correct by standard terminology.


Verification / Alternative check:
Consult normalization steps (e.g., 3NF) where determinants play a role in identifying transitive dependencies.



Why Other Options Are Wrong:

  • “Incorrect” contradicts accepted terminology.
  • Conditions about keys or minimality are unnecessary to name the determinant.


Common Pitfalls:
Confusing “determinant” with “candidate key.” A candidate key is a minimal determinant of all attributes in the relation.



Final Answer:
Correct

Discussion & Comments

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