Computer Sciences > GATE 2014 SET-3 > Functional Dependencies
The following functional dependencies hold for relations R(A, B, C) and S(B, D, E):
B → A,
A → C
The relation R contains 200 tuples and the relation S contains 100 tuples. What is the maximum number of tuples possible in the natural join R ⋈ S?
B → A,
A → C
The relation R contains 200 tuples and the relation S contains 100 tuples. What is the maximum number of tuples possible in the natural join R ⋈ S?
Correct : b
Similar Questions
The symbol → indicates functional dependency in the context of a relational database. Which of the following options is/are TRUE?
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...
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,...
Total Unique Visitors
Loading......