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

asked in Databases by Boss (5.1k points) | 39 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 Veteran (10.4k 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

33,701 questions
40,250 answers
38,858 users