GATE Papers >> CSE >> 2007 >> Question No 60

Question No. 60 CSE | GATE 2007

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?

{e.name | employee(e)
                (x) [¬employee(x) x.supervisorName ≠ e.name x.sex = "male" ] }


Answer : (B) Names of employees with no immediate male subordinates.


Comments
No Comments
Leave a comment