Difficulty: Easy
Correct Answer: Correct — it is a constraint relating attributes (determinant → dependent)
Explanation:
Introduction / Context: Functional dependencies (FDs) formalize how some attributes determine others in a relation. They are foundational to normalization decisions (3NF, BCNF) and to reasoning about keys and redundancy.
Given Data / Assumptions:
Concept / Approach: Because both sides of an FD are attribute sets of the same relation, it is indeed a relationship among attributes (often between a determinant set and a dependent set). It does not represent an inter-relation constraint like referential integrity, nor does it require composite keys or foreign keys to exist.
Step-by-Step Solution:
Identify objects involved in an FD: attributes within one relation.Interpretation: agreement on X implies agreement on Y — a constraint among attributes.Therefore, the statement characterizes FDs correctly.No additional conditions (keys, foreign keys) are required.Verification / Alternative check: Example: In Student(roll_no, name), roll_no → name is an FD between attributes; if roll_no repeats, the name must repeat identically.
Why Other Options Are Wrong:
Common Pitfalls: Mistaking FDs for correlations in a sample; assuming FDs require keys; conflating FDs with foreign keys.
Final Answer: Correct — it is a constraint relating attributes (determinant → dependent)
Discussion & Comments