-
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: p is the rename operator)
π name (rsex female (student)) - π name (studentsex Po , x , m
-
- names of girl students with the highest marks
- names of girl students with more marks than some boy student
- names of girl students with marks not less than some boy student
- names of girl students with more marks than all the boy students
- names of girl students with the highest marks
Correct Option: D
This query first computes join where marks are less than or equal to marks are less than or equal to max marks, & then selects the name of all the girl students with more marks than all the boys students.