Consider the following three tables 𝑅,𝑆 and 𝑇. In this question, all the…

UGC NET 2015

Consider the following three tables 𝑅,𝑆 and 𝑇.Β In this question, all the join operations are natural joinsΒ (β‹ˆ).Β (πœ‹)Β is the projection operation of a relation:

RAB1232567898SBC6224818325TAC7112935435\begin{array}{|ccc|} \hline & R & \\ \hline A && B \\ \hline 1 && 2 \\ 3 && 2 \\ 5 && 6 \\ 7 & &8 \\ 9 && 8 \\ \hline \end{array} \begin{array}{|ccc|} \hline & S & \\ \hline B && C \\ \hline 6 && 2 \\ 2 && 4 \\ 8 && 1 \\ 8 & &3 \\ 2 && 5 \\ \hline \end{array} \begin{array}{|ccc|} \hline & T & \\ \hline A && C \\ \hline 7 && 1 \\ 1 && 2 \\ 9 && 3 \\ 5 & &4 \\ 3 && 5 \\ \hline \end{array}

Possible answer tables for this question are also given as below:

ABC124125324325562781783981983(a)ABC122325564781983(b)ABC162325524781983(c)ABC325781983(d)\underset{\text{(a)}}{\begin{array}{|ccc|} \hline A & B & C \\ \hline 1 & 2& 4 \\ 1 &2& 5 \\ 3 &2& 4 \\ 3 &2& 5 \\ 5 & 6 &2 \\ 7 & 8 & 1 \\ 7 & 8 & 3 \\ 9 & 8 & 1 \\ 9 & 8 & 3 \\ \hline \end{array}} \underset{\text{(b)}}{\begin{array}{|ccc|} \hline A & B & C \\ \hline 1 & 2& 2 \\ 3 &2& 5 \\ 5 &6& 4 \\ 7 &8& 1 \\ 9 & 8 &3 \\ \hline \end{array}} \underset{\text{(c)}}{\begin{array}{|ccc|} \hline A & B & C \\ \hline 1 & 6& 2 \\ 3 &2& 5 \\ 5 &2& 4 \\ 7 &8& 1 \\ 9 & 8 &3 \\ \hline \end{array}} \underset{\text{(d)}}{\begin{array}{|ccc|} \hline A & B & C \\ \hline 3 & 2& 5 \\ 7 &8& 1 \\ 9 & 8 &3 \\ \hline \end{array}}

What is the resulting table ofΒ πœ‹A,B(Rβ‹ˆT)β‹ˆπœ‹B,C(Sβ‹ˆT)πœ‹_{ A,B} (R \bowtie T) \bowtie πœ‹_{B,C} (S \bowtie T)Β ?

  1. A.

    (a)

  2. B.

    (b)

  3. C.

    (c)

  4. D.

    (d)

Attempted by 131 students.

Sign up free to check your answer

Sign up free

Explore the full course: Uppsc Polytechnic Lecturer 2025 Cs

Loading lesson…