GATE Overflow Test Series | Mixed Subjects | Test 3 | Question: 23

Question

Given that the relations $R(A,B)$ and $S(C,D)$.
$$\overset{R}{\begin{array}{|c|c|c|c|}
\hline
\textbf{A} & \textbf{B}
\\\hline
1 & a
\\\hline
2 & c
\\\hline
\end{array}}\qquad \overset{S}{\begin{array}{|c|c|c|c|}
\hline
\textbf{C} & \textbf{D}
\\\hline
1 & b
\\\hline
3 & d
\\\hline
\end{array}}$$
If the number of rows in $R \Join_{\langle A = C\rangle} S = a$(natural join), the number of rows in $R ⟕_{\langle A = C\rangle} S = b$ (left outer join), the number of rows in $R ⟖_{\langle A = C\rangle} S = c$ (right outer join), and the number of rows in $R ⟗_{\langle A = C\rangle} S = d$ (full outer join), then the value of $2a + 3b + 5c + 7d = $ ________

Answer 1

Here, $a = 1,b = 2,c = 2,$ and $d = 3.$

Now, the value of $2a + 3b + 5c + 7d = 2+6+10+21 = 39.$