Computer Sciences > GATE 2024 Set-2 > Relational Algebra
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
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
Correct : c
Similar Questions
Consider a database that has the relation schemas EMP (EmpId, EmpName, DepId), and DEPT(DeptName, DeptId). Note that the DepId can be permitted to be NULL in th...
Consider the following two relations, R(A,B) and S(A,C);
The total number of tuples obtained by evaluating the following expression σB<C(R ⨝R.A=S.AS) is...
A relation r(A, B) in a relational database has 1200 tuples. The attribute A has integer values ranging from 6 to 20, and the attribute B has integer values ran...
Total Unique Visitors
Loading......