Register

Find no of Tuples

327 views
1 votes
1 votes

consider the selection of the form sa<=200(r) where r is a relation with 1000 tuples . Asume attribute values of A among the tuples are uniformly distributed in interval [1,500]. The number of tuples return by given query are ___ .

User Avatar

1 Answer

Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

0 votes
0 votes
1 answer
2
vaishali jhalani asked Jan 11, 2017
951 views
No of tuples
Ans given: 100
Ans given: 100
User Avatar
3 votes
3 votes
2 answers
3
saket nandan asked Mar 21, 2016
2,369 views
maximum no of tuples
Consider the relation R1( P, Q, R, S ) and R2 ( R, G, T, U ) The relation R1 has 20 tuples and R2 has 10 tuples then maximum number of tuples in R1 &#10197; R2 is .......................?
Consider the relation R1( P, Q, R, S ) and R2 ( R, G, T, U )The relation R1 has 20 tuples and R2 has 10 tuples then maximum number of tuples in R1 &#10197; R2 is ...........
User Avatar
0 votes
0 votes
3 answers
4
uzumzki asked Aug 17, 2015
1,974 views
if natural join is done then min and max no. of tuples if referential integrity is taken and not
R(ABC)     S(BDE) F:A->B      B ->C     B->D     D->E AND R HAS 100 TUPLES AND S HAS 200
R(ABC)     S(BDE)F:A->B      B ->C     B->D     D->EAND R HAS 100 TUPLES AND S HAS 200
User Avatar
Link Copied!