GATE CSE
First time here? Checkout the FAQ!
x
0 votes
84 views

Ans given: 100

asked in Databases by Boss (6.1k points)   | 84 views

1 Answer

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

 

answered by Active (2.3k points)  
selected by
I thought, C in Q is foreign key pointng to C in P and similarly E in Q referring to E in R.

So, we should not consider foreign key even if there is common attribute between two relation unless it is mentioned explicitly. ??
@Vijay. Yes. We shouldn't consider unless explicitly stated because we have satisfied the conditions they have given.
But, if options are given, we need to consider that C is foreign key in Q   :P
....
maximum tupples can be 200.


Top Users Aug 2017
  1. Bikram

    5276 Points

  2. ABKUNDAN

    4730 Points

  3. akash.dinkar12

    3530 Points

  4. manu00x

    3492 Points

  5. rahul sharma 5

    3188 Points

  6. makhdoom ghaya

    2700 Points

  7. just_bhavana

    2432 Points

  8. stblue

    2244 Points

  9. Tesla!

    2090 Points

  10. pawan kumarln

    1876 Points


25,075 questions
32,231 answers
75,118 comments
30,240 users