retagged by
1,043 views
8 votes
8 votes

Consider the following relation:
R (A B C) A primary key with 100 tuples.
S (E F G) E primary key with 50 tuples.
T (AE D) AE primary key with 80 tuples.
U (D G H) H primary key with 10 tuples.
The maximum number of possible records in the result of (R JOIN S JOIN T JOIN U)

retagged by

1 Answer

0 votes
0 votes
I think first of all we have to join R and T then (R join T) join S which will give 50 tuples but in between ((R join T) join S) and leftover U attribute D and G is common which is not key of any of the schema hence in this case number of tuples should be 50*10= 500 as it will behave like Cross product.

Related questions

3 votes
3 votes
2 answers
1
saket nandan asked Mar 21, 2016
2,308 views
Consider the relation R1( P, Q, R, S ) and R2 ( R, G, T, U )The relation R1 has 20 tuples and R2 has 10 tuples then maximum number of tuples in R1 ⟕ R2 is ...........
5 votes
5 votes
4 answers
2
learncp asked Sep 5, 2015
3,322 views
Why is the maximum number of tuples in full outer join equal to m*n, where m is the number of attributes in one relation and n is the attribute count in other ?Can someon...
1 votes
1 votes
3 answers
3
aditi19 asked May 18, 2019
1,200 views
Class(name, meets_at, room, fid)Faculty(fid, fname, deptid)Find the names of faculty members who teach in every room in which some class is taught