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:
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