Consider the relation employee(name, sex, supervisorName) with name as the…

PYQ 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?

  1. A.

    Names of employees with a male supervisor.

  2. B.

    Names of employees with no immediate male subordinates.

  3. C.

    Names of employees with no immediate female subordinates.

  4. D.

    Names of employees with a female supervisor.

Attempted by 115 students.

Sign up free to check your answer

Sign up free

Explore the full course: Zero To Hero

Loading lesson…