in Databases
877 views
0 votes
0 votes

Ans given: 100

in Databases
877 views

1 Answer

0 votes
0 votes
Best answer

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

4 Comments

edited by
But, if options are given, we need to consider that C is foreign key in Q   :P
0
0
edited by
....
0
0
maximum tupples can be 200.
0
0

Related questions

2 votes
2 votes
1 answer
4