The GATE Grind

GATE 2007 CS – Question 60

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

employee(name, sex, supervisorName) has key name; supervisorName names an immediate supervisor. What does $\{e.name\mid employee(e)\land\forall x[\neg employee(x)\lor x.supervisorName\ne e.name\lor x.sex=\text{male}]\}$ produce?

  1. Employees with a male supervisor.
  2. Employees with no immediate male subordinates.
  3. Employees with no immediate female subordinates.
  4. Employees with a female supervisor.

Practise this question in The GATE Grind →

Show answer and explanation

Correct answer: (C) Employees with no immediate female subordinates.

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 →