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

  1. A.

    1

  2. B.

    2

  3. C.

    3

  4. D.

    4

Attempted by 276 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…