in Databases edited by
395 views
0 votes
0 votes

Suppose we have 2 tables R1(ABCD), R2(DE) . R1 has 500 entries whereas R2 has 1500 entries. Here D is a candidate key. If we join them using natural join. How many entires would be there in the resultant table and why ?

Examples would be appreciated..

in Databases edited by
395 views

4 Comments

500?
0
0
Nope.. 1500.
0
0
500....we have 1500 entries in r2 which are distinct as d is primary key...now for maximum if every d entry of r1 is distinct we will have 500 entries if not we will have less than 500 entries...so maximum 500 entries possible
0
0

1 Answer

0 votes
0 votes
500 tuple is the answer.

Related questions

1 vote
1 vote
0 answers
2