Computer Sciences > GATE 2026 SET-1 > Functional Dependencies
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?
A
If ( {P, Q} → {R} and {P} → {R} ), then {Q} → {R}
B
If {P, Q} → {R}, then ( {P} → {R} or {Q} → {R} )
C
If ( {P} → {R} and {Q} → {S} ), then {P, Q} → {R, S}
D
If {P} → {R}, then {P, Q} → {R}

Correct : c,d

Similar Questions

The symbol → indicates functional dependency in the context of a relational database. Which of the following options is/are TRUE?
#880 MSQ
Suppose the following functional dependencies hold on a relation U with attributes P, Q, R, S, and T: P → QR RS → T Which of the following function...
#1096 MSQ
The following functional dependencies hold for relations R(A, B, C) and S(B, D, E):B → A,A → CThe relation R contains 200 tuples and the relation S contains 100...
#1331 MCQ

Related Topics

No tags found

Unique Visitor Count

Total Unique Visitors

Loading......

Question Options

Contributed by: