Register

ISI-2017 C3 (a)

1,057 views
0 0 votes
Let R(A,B,C) be a relation with primary key (A) and S(A,D,E) a relation with primary key (A,D). Each of the relations has n tuples. If the number of tuples in R natural join S is m, then determine the number of tuples in R natural left outer join S.

1 Answer

1 1 vote

first row  of relation R is join with each row's with relation S. then we get maximum tuples.

Voting & Accepting an answer helps improve the community
← Previous · Morris Mano-chapter ...Next → · Modification of GATE...
← Previous in category · DBMS (Relational alg...Next in category → · Madeeasy workbook
Position:
Show:

Related questions

0 0 votes
1 1 answer
1.5k
1.5k views
Aakanchha asked May 3, 2018
1,461 views
ISI 2017 PCB C3 (A)
Let R(A, B, C) be a relation with primary key (A) and S(A, D, E) a relation with primary key (A, D). Each of the relations has n tuples. If the number of tuples in R natu...
0 0 votes
1 1 answer
551
551 views
Debasmita Bhoumik asked May 12, 2018
551 views
ISI CSB 2017 C6
Let P = {P1(x1, y1), P2(x2, y2), . . . , Pn(xn, yn)} be a set of n points located within a rectangle such that none of the points touches its boundary. The top-left corne...
1 1 vote
1 answers 1 answer
923
923 views
Tesla! asked Apr 28, 2018
923 views
ISI 2017 PCB A2
Let $a,b,c$ and $d$ be real number such that $a+b=c+d$ and $ab=cd$. Prove that $a^{n}+b^{n}=c^{n}+d^{n}$ for all positive integer $n$.
1 1 vote
1 answers 1 answer
662
662 views
Debasmita Bhoumik asked May 12, 2018
662 views
ISI CSB C5 B
Consider the Boolean function F(x1, x2, . . . , x10) realised by the following combinational circuit.Determine the number of input combinations for which the output funct...