GATE 2007 CS – Question 59
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?
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
- GATE 2007 CS Q60
- GATE 2007 CS Q61
- GATE 2026 CS (CS1) Q30
- GATE 2026 CS (CS1) Q43
- GATE 2025 CS (CS1) Q39
- GATE 2025 CS (CS1) Q55
All Relational Model: Relational Algebra, Tuple Calculus, SQL questions →