Suppose we have three schemas:
Instructor(
id:integer
, name:string, age:integer, salary:real)
Works(
eid:integer, did:integer
, pct-time:integer)
Dept(
did:integer
, budget:real, managerid:integer)
Let me start this by showing two similar problems:
a) Find the manager ids of instructors who manage all departments with budgets greater than $1 million.
b) Find the manager ids of instructors who only manage departments with budgets greater than $1 million.
My problem is that I cannot figure out why the u=[managerid] = s[managerid]
and u[budget] > 1000000
constraints are switched. Can someone explain in words why the order affects the result?