Difficulty: Easy
Correct Answer: A → B.
Explanation:
Introduction / Context:
Functional dependencies are derived from observed or intended business rules. This question asks you to infer a dependency from observed consistency.
Given Data / Assumptions:
Concept / Approach:
If B is uniquely determined by A, we express this as A determines B. Since C can vary for the same A, A does not determine C, and therefore A does not determine the pair (B, C) either.
Step-by-Step Solution:
Verification / Alternative check:
Construct a small sample with fixed pairs of A and B but multiple C values; you will see that B is functionally dependent on A while C is not.
Why Other Options Are Wrong:
Common Pitfalls:
Assuming that if A determines one attribute, it determines all related attributes. Each dependency must be justified independently.
Final Answer:
A → B.
Discussion & Comments