The relation schema, Person(pid, city), describes the city of residence for every person uniquely identified by pid (pid is underlined, the key). 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
