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

Ans given: 100

asked in Databases by Boss (6k points)   | 81 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.2k 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 Jun 2017
  1. Bikram

    3704 Points

  2. Arnab Bhadra

    1502 Points

  3. Hemant Parihar

    1502 Points

  4. Niraj Singh 2

    1481 Points

  5. junaid ahmad

    1432 Points

  6. Debashish Deka

    1402 Points

  7. Rupendra Choudhary

    1226 Points

  8. rahul sharma 5

    1222 Points

  9. Arjun

    1168 Points

  10. pawan kumarln

    1164 Points

Monthly Topper: Rs. 500 gift card
Top Users 2017 Jun 26 - Jul 02
  1. pawan kumarln

    296 Points

  2. akankshadewangan24

    214 Points

  3. Arjun

    208 Points

  4. Debashish Deka

    156 Points

  5. Hira Thakur

    130 Points


23,414 questions
30,125 answers
67,508 comments
28,443 users