Register

maximum size of join

• reopened by
470 views

1 Answer

0 votes
0 votes
1500
User Avatar
Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

5 votes
5 votes
4 answers
2
learncp asked Sep 5, 2015
3,404 views
Why is the maximum number of tuples in full outer join equal to m*n ?
Why is the maximum number of tuples in full outer join equal to m*n, where m is the number of attributes in one relation and n is the attribute count in other ? Can someone give an example to illustrate this ?
Why is the maximum number of tuples in full outer join equal to m*n, where m is the number of attributes in one relation and n is the attribute count in other ?Can someon...
User Avatar
0 votes
0 votes
2 answers
3
iita asked Feb 7, 2017
656 views
maximum records in join operation ME mock
Consider the following relation: R (A B C) A primary key with 100 tuples. S (E F G) E primary key with 50 tuples. T (AE D) AE primary key with 80 tuples. U (D G H) H primary key with 10 tuples. The maximum number of possible records in the result of R⋈S⋈T⋈U _______.
Consider the following relation:R (A B C) A primary key with 100 tuples.S (E F G) E primary key with 50 tuples.T (AE D) AE primary key with 80 tuples.U (D G H) H primary ...
User Avatar
1 votes
1 votes
2 answers
4
Sanjay Sharma asked Jan 7, 2017
6,645 views
maximum tuples in natural join
Consider 2 relations R and S having 3 tuples in R and 2 tuples in S . What is the max no of tuples that could appear in the natural join of R and S a) 6 b) 2 C) 3 d)5 ans should be 6( cross join ) or 2(as equi join ) as both these forms related to natural join in way or other
Consider 2 relations R and S having 3 tuples in R and 2 tuples in S . What is the max no of tuples that could appear in the natural join of R and S a) 6 b) 2 C) 3 d)5a...
User Avatar
Link Copied!