Consider the relations $r(A, B)$ and $s(B, C)$, where $s.B$ is a primary…

GATE · 2018 · CS · Computer Science & IT

Consider the relations $r(A, B)$ and $s(B, C)$ , where $s.B$ is a primary key and $r.B$ is a foreign key referencing $s.B$ . Consider the query

$Q: 𝑟 ⋈ (𝜎𝐵<5(𝑠))$

Let $LOJ$ denote the natural left outer-join operation. Assume that $r$ and $s$ contain no null values.

Which one of the following queries is NOT equivalent to Q?

Attempted by 161 students.

Consider the relations \(r(A, B)\) and \(s(B, C)\), where \(s.B\) is a primary…