Find the ID, name, dept name, salary for instructors whose salary is greater than $80,000 .
(a) {t | t ε instructor ∧ t[salary] > 80000}
(b) Э t ∈ r (Q(t))
(c) {t | Э s ε instructor (t[ID] = s[ID]∧ s[salary] > 80000)}
(d) None of the mentioned
This question was posed to me in a job interview.
The question is from Tuple Relational Calculus and Domain Relational Calculus in division Relational Algebra of Database Management