The relation schema, Person(pid,city), describes the city of residence for…

PYQ GATE 2024

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 340 students.

Sign up free to check your answer

Sign up free

Explore the full course: Zero To Hero

Loading lesson…