Consider the relation Student (name, sex, marks), where the primary key is…

GATE · 2004 · CS

Consider the relation Student (name, sex, marks), where the primary key is shown underlined, pertaining to students in a class that has at least one boy and one girl. What does the following relational algebra expression produce? (Note: r is the rename operator).

1. A.

   names of girl students with the highest marks

2. B.

   names of girl students with more marks than some boy student

3. C.

   names of girl students with marks not less than some boy students

4. D.

   names of girl students with more marks than all the boy students

Attempted by 139 students.