in Databases edited by
505 views
1 vote
1 vote
consider $r1(A,B,C),r2(C,D,E)$ and $r3(F,G)$ with primary key $A,C,F, r1$ has $150 ,r2$ has $100$ and $r3$ has $75$ tuples the number of tuples in $r1$ natural join $r2$ natural join $r3?$
in Databases edited by
505 views

4 Comments

@Shubhgupta Are u sure when no common attribute Cross Product ???Somewhere on GO already i have seen it will return empty relation.

0
0

  when attributes name is common and no match found in entries then it will be 0. But if no common attribute then natural join will be CP

2
2

Natural join will return the output of the cross product when no common attribute in two different relations.

You can run the query and check it

1
1

1 Answer

0 votes
0 votes
7500

100 A join B

Then 75 B join C

1 comment

 

can you explain?

how you got $7500?$

0
0

Related questions