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: r ⋈ (σ_{B<5}(s))
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?
- (A)
σ_{B<5}(r ⋈ s)
- (B)
σ_{B<5}(r LOJ s)
- (C)
r LOJ (σ_{B<5}(s))
- (D)
σ_{B<5}(r) LOJ s
