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:
From the observation: A values map to exactly one B value, so A → B holds.Because C differs for the same A, A → C does not hold.Because C varies, A → (B, C) cannot hold either.No information supports (B, C) → A.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