Multiple choice

Consider the relation employee (name, sex, supervisor Name) with name as the key; supervisor Name gives the name of the supervisor of the employees under consideration. What does the following Tuple Relational Calculus query produce? { e. name| employee (e) $\land$ $\forall X$[$\neg$employee (x) $\lor$ x.supervisorName $\ne$e.name $\lor$ x.sex = “male”] }

  1. Names of employees with a male supervisor.

  2. Names of employees with no immediate male supervisor.

  3. Names of employees with no immediate female supervisor.

  4. Names of employees with a female supervisor.

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation