3 a) e.Lname, e.Fname | EMPLOYEE(e) AND e.DNO=5 AND (∃ p) (∃ w) (WORKS_ON(w) AND PROJECT(p) AND e.Ssn=w.Essn AND w.Pno=p.Pnumber AND p.Pname='ProductX' AND w.Hours>10 )b) e.Lname, e.Fname | EMPLOYEE(e) AND (∃ d) ( DEPENDENT(d) AND e.Ssn=d.Essn AND e.FNAME=d.DEPENDENT_NAME )c) e.Lname, e.Fname | EMPLOYEE(e) AND (∃ s) ( EMPLOYEE(s) AND s.Fname='Franklin' AND s.Lname='Wong' AND e.SUPERSSN=s.Ssn )4.a) qs | (∃ t) ( EMPLOYEE(qrstuvwxyz) AND (FORALL b) (NOT(PROJECT(abcd)) OR (∃ e) (∃ f) (WORKS_ON(efg) AND e=t AND f=b) )b) qs | (∃ t) ( EMPLOYEE(qrstuvwxyz) AND NOT(∃ a) ( WORKS_ON(abc) AND a=t ) )c) qsv | (∃ t) (∃ z) ( EMPLOYEE(qrstuvwxyz) AND (∃ b) (∃ c) (∃ e) (∃ f) ( WORKS_ON(efg) AND PROJECT(abcd) AND t=e AND f=b AND c='Houston' ANDNOT(∃ h) NOT∃ i) ( DEPT_LOCATIONS(hi) AND z=h AND i='Houston' ) )a) P Q R A B C10 a 5 10 b 610 a 5 10 b 525 a 6 25 c 3b)P Q R A B C15 b 8 10 b 615 b 8 10 b 5c)P Q R A B C10 a 5 10 b 610 a 5 10 b 525 a 6 25 c 315 b 8 -- -- --d)P Q R A B C15 b 8 10 b 615 b 8 10 b 5-- -- -- 25 c 3e)P Q R10 a 515 b 825 a 610 b 625 c 310 b 5f)P Q R A B C10 a 5 10 b
View Full Document