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

Ans given: 100

asked in Databases by Boss (6k points)   | 79 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 Apr 2017
  1. akash.dinkar12

    3508 Points

  2. Divya Bharti

    2542 Points

  3. Deepthi_ts

    2040 Points

  4. rude

    1966 Points

  5. Tesla!

    1768 Points

  6. Shubham Sharma 2

    1610 Points

  7. Debashish Deka

    1588 Points

  8. Arunav Khare

    1454 Points

  9. Kapil

    1424 Points

  10. Arjun

    1420 Points

Monthly Topper: Rs. 500 gift card

22,075 questions
28,041 answers
63,230 comments
24,135 users