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

asked in Databases by Active (3.7k points) | 47 views
0
R is not the primary key in relation r2 therefore redundant data will result maximum selection of tuples.
0
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 (12.2k points)
selected by
0

when 1500 wud be the answer then???

plz check this too. . .https://gateoverflow.in/3553/gate2006-it-14

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

Related questions

–1 vote
1 answer
1
asked Sep 26 in Databases by aoao (87 points) | 24 views
+2 votes
2 answers
4
+1 vote
1 answer
6
asked Jul 6, 2017 in Databases by rahul sharma 5 Boss (25.8k points) | 242 views


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

44,084 questions
49,595 answers
162,959 comments
65,791 users