Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
|
Question 462
|
Consider the relations R(A, B) and S(B, C) and the following four relational algebra queries over R and S:
I. ΠA, B (R ⨝ S)
II. R ⨝ ΠB(S)
III. R ∩ (ΠA(R) × ΠB(S))
IV. ΠA, R.B (R × S)
where R⋅B refers to the column B in table R.
One can determine that:
|
I, III and IV are the same query.
|
|
|
II, III and IV are the same query.
|
|
|
I, II and IV are the same query.
|
|
|
I, II and III are the same query.
|
Question 462 Explanation:
Correct Answer: D
Question 462 Explanation: