The relation schema, Person(pid,city), describes the city of residence for…
GATE · 2024 · CS · Set 2 · Computer Science & IT
The relation schema, Person(pid,city), describes the city of residence for every person uniquely identified by pid. The following relational algebra operators are available: selection, projection, cross product, and rename.
To find the list of cities where at least 3 persons reside, using the above operators, the minimum number of cross product operations that must be used is
- A.
1
- B.
2
- C.
3
- D.
4
Attempted by 276 students.
Sign up free to check your answer
Sign up freeLoading lesson…