894 views

1 Answer

Best answer
0 votes
0 votes

Lets take an example, Below are three instances of table with ratio of tuples equal to the original relation.

A B C
 Y  Y  L
 P  Q  M
 C  D  N
 X  Z  O
C D E
 L  Z  A
 M  Z  A
 N  Z  A
 L  Z  B
 M  Z  B
 O  Z  B
E F
 A  Z
 B  Z

If we join tem in any way the resulting table will have 6 tuples 
We can thus conclude that P join Q join R will result in 300 tuples.

A B C D E F
 Y  Y  L  Z  A  Z
 Y  Y  L  Z  B  Z
 P  Q  M  Z  A  Z
 P  Q  M  Z  B  Z
 C  D  N  Z  A  Z
 X  Z  O  Z  B  Z
selected by

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 ...........
0 votes
0 votes
1 answer
2
srestha asked Dec 16, 2017
1,520 views
Consider the relation schema:Student(roll no, name course no)Enroll(roll no, course no,course name)The number of tuples in the student and enroll table is 30 and 40 respe...
3 votes
3 votes
2 answers
3
iarnav asked Dec 6, 2017
1,254 views
Say we have two relations R (a,b,c) and S (b,d,e).Now, R has 200 tuples and S has 300 tuples. What will be Minimum number of tuples when we do R ⋈ S ( ⋈ = Natural Joi...
2 votes
2 votes
1 answer
4