edited by
457 views
1 votes
1 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 \: \text{ natural join } S$ is $m$, then determine the number of tuples in $R$ $\text{ natural left outer join } S$.
edited by

1 Answer

1 votes
1 votes
Since there are $\text{m}$ rows in the natural join of R and S which contains the common elements. Left outer join of R and S will contain common elements of R, S and left over elements of R which will be $\text{(n-m)}$

Hence total no. of rows in $\text{R left outer join S = m + (n-m)} \\\ = n$

Related questions

0 votes
0 votes
2 answers
3
go_editor asked Sep 20, 2018
394 views
Write a complete ANSI C code using recursion to calculate the $sum(s)$ of the digits of an integer number (i) consisting of maximum 5 digits. For example, (1) = if $i=123...
1 votes
1 votes
1 answer
4
go_editor asked Sep 20, 2018
1,583 views
An operating system contains three resource classes. The number of resource units in these classes are $7, 7\ \text{and} \ 10$ respectively. The current resource allocati...