The Gateway to Computer Science Excellence
First time here? Checkout the FAQ!
+2 votes

asked in Databases by Active (3.6k points) | 44 views
R is not the primary key in relation r2 therefore redundant data will result maximum selection of tuples.
b is correct answer.

1 Answer

+1 vote
Best answer
Given R1(P, Q, R) and R2(R ,U, V) where R is primary key in R1 and U is primary key in R2.
R in R1 is primary key so it should contain unique values assume 1,2,3,......1500(1500tuples)
There is no constraint on R in R2 so it can contain duplicate values assume 1,1,1,...1(2000 tuples)
Natural join is performed on the Common attribute i.e R
1 in R( R1 table) can map with 2000 1's in R( R2 table).
Hence maximum 2000 tuples are possible in natural join
answered by Boss (11.5k points)
selected by

when 1500 wud be the answer then???

plz check this too. . .

Now I got it clearly....  Thank u so much

Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true

39,585 questions
46,709 answers
57,881 users