Consider student (name, sex, marks) is relation where name is primary key then…

Consider student (name, sex, marks) is relation where name is primary key then the following relational algebra expression.

π name (σ sex=’female’ (student)−(π name (student)⋈ ρ n,x,m (student) on sex=’female’ ∧ x=’male’∧ marks≤m) produces

  1. A.

    Names of girls with highest marks

  2. B.

    Names of girls with more marks than some boy

  3. C.

    Names of girls with marks more than all the boys

  4. D.

    Names of girls with marks not less than some boy

Attempted by 130 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…