The GATE Grind

GATE 2007 CS – Question 59

Databases · Relational Model: Relational Algebra, Tuple Calculus, SQL · 2 marks · Multiple choice

Relations studInfo(studId, name, sex), key studId, and enroll(studId, courseId), key(studId, courseId), record students and courses. Every course has at least one male and one female. What does $\pi_{courseId}((\pi_{studId}(\sigma_{sex=\text{female}}(studInfo))\times\pi_{courseId}(enroll))-enroll)$ represent?

  1. Courses with all female students enrolled.
  2. Courses with a proper subset of female students enrolled.
  3. Courses with only male students enrolled.
  4. None of these.

Practise this question in The GATE Grind →

Show answer and explanation

Correct answer: (B) Courses with a proper subset of female students enrolled.

Explanation

We are sorry we couldn't write detailed soluition for this, we are working on it!, please consider asking your own AI, its just 2-3 clicks with very minimum effort

More Relational Model: Relational Algebra, Tuple Calculus, SQL questions

All Relational Model: Relational Algebra, Tuple Calculus, SQL questions →