Q. 35 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).
The condition in join is “(sex = female ^ x = male ^ marks ≤ m)”
(A) names of girl students with the highest marks
(B) names of girl students with more marks than some boy student
(C) names of girl students with marks not less than some boy student
(D) names of girl students with more marks than all the boy students
Answer: (D)
Explanation:
