GATE | GATE-CS-2007 | Question 60

Consider the relation employee(name, sex, supervisorName) with name as the key. supervisorName gives the name of the supervisor of the employee under consideration. What does the following Tuple Relational Calculus query produce?

(A) Names of employees with a male supervisor.
(B) Names of employees with no immediate male subordinates.
(C) Names of employees with no immediate female subordinates.
(D) Names of employees with a female supervisor.

Answer: (C)
Explanation: See question 2 of https://www.geeksforgeeks.org/database-management-systems-set-11/
Quiz of this Question