Home » Database » Database miscellaneous » Question

Database miscellaneous

  1. 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
    1. names of girl students with the highest marks
    2. names of girl students with more marks than some boy student
    3. names of girl students with marks not less than some boy student
    4. names of girl students with more marks than all the boy students
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.



Your comments will be displayed only after manual approval.