Let P,Q,R and S be the attributes of a relation in a relational schema. Let X → Y indicate functional dependency in the context of a relational database, where X,Y ⊆{P,Q,R,S}. Which of the following options is/are always true?
Correct Answer :
If ({P,Q} → {R} and {P} → {R}), then {Q} → {R}
If ({P} → {R} and {Q} → {S}), then {P,Q} → {R,S}
If ({P} → {R} and {Q} → {S}), then {P,Q} → {R,S}
If {P} → {R}, then {P,Q} → {R}
Solution :
The correct options are:
1. If and , then
2. If , then
Let's analyze the validity of each statement step-by-step using the standard rules of functional dependencies in relational databases, known as Armstrong's Axioms.
1. Analyzing the statement: If and , then
This is the composition rule (sometimes referred to as the additive rule), which can be derived from Armstrong's Axioms as follows:
- Given , we can apply the rule of augmentation by adding to both sides. This gives us:
(Step 1)
- Similarly, given , we can apply the rule of augmentation by adding to both sides. This gives us:
(which is equivalent to ) (Step 2)
- Using the transitivity rule on Step 1 () and Step 2 (), we get:
Therefore, this option is always true.
2. Analyzing the statement: If , then
This is a direct application of the augmentation rule in Armstrong's Axioms:
- If we have a functional dependency , we can augment the left-hand side with any attribute set to yield (or ).
- Applying this rule to by augmenting the left-hand side with , we obtain:
- By decomposition (or reflectivity since ), we get:
Therefore, this option is also always true.
Why the other choices are incorrect / not always true:
- If , then ( or ): This is invalid. For example, if we have a relation schema with attributes , , and representing (StudentID, CourseID) → Grade, neither StudentID → Grade nor CourseID → Grade holds individually.
- If ( and ), then : This does not necessarily follow. The fact that the combination of and determines , and alone also determines , tells us nothing about whether alone can determine . Therefore, is not guaranteed.
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.