Consider a relation R(A, B, C, D) and functional dependencies of X → Y. Which of the following statement are correct?
Correct Answer :
If P → R and Q → S, then PQ → RS.
If P → R, then PQ → R.
Solution :
The correct statements are:
1. If P → R and Q → S, then PQ → RS.
2. If P → R, then PQ → R.
Let us analyze the correctness of each statement step-by-step using the formal inference rules for functional dependencies (also known as Armstrong's Axioms).
Statement 1: If and , then .
This statement is correct and is known as the Composition Rule. We can derive it using Armstrong's Axioms:
1. Given , by applying the augmentation rule (augmenting both sides with ), we get:
(since is same as )
3. By applying the transitivity rule to and , we obtain:Statement 2: If , then .
This statement is correct and is known as the Augmentation Rule (specifically, a direct consequence of it).
According to the augmentation rule, if holds, we can append any set of attributes to both the left and right sides to get:
Let us also verify why the other statements are incorrect to complete the explanation:
Statement 3 (Incorrect): If , then or .
This is incorrect because and might jointly determine , but neither of them can determine individually. For example, in a relation where a customer buys a product at price , the price depends on both the customer and the product combined, but not on the customer alone or the product alone.
Statement 4 (Incorrect): If and , then .
This is incorrect. Knowing that independently determines does not imply that also determines . For example, if we have and , it does not mean must hold. Here, could be an entirely irrelevant attribute.
Access expert-curated educational resources and study materials—completely free.
Create, conduct, and manage professional online assessments with Mindyard. Perfect for teachers and institutes.
Copyright © 2026 Mindyard. All Rights Reserved.