Answer Happy

Posted: **Tue Jul 05, 2022 10:27 am**

: Refer To The Company Schema Below To Solve The Queries Employee Fname Minit Lname San Aaaa Department Dname Dnumber Mgr 1 (31.66 KiB) Viewed 11 times

: Refer To The Company Schema Below To Solve The Queries Employee Fname Minit Lname San Aaaa Department Dname Dnumber Mgr 2 (29.61 KiB) Viewed 11 times

Refer to the company schema below to solve the queries EMPLOYEE Fname Minit Lname San AAAA DEPARTMENT Dname Dnumber Mgr_ssn Mgr_start_date DEPT LOCATIONS Dnumber Dlocation PROJECT Pname Pnumber Plocation WORKS ON Essn Bdate Address Sex Salary Pno Hours Dnum DEPENDENT Essn Dependent_name Sex Bdate Relationship Super_ssn Dno
estion 5) (13 points) Write the following queries in Relational Algebra 1) Retrieve the names of dependents of the research department manager 2) Retrieve the names of employees who do not have daughters 3) For every department that controls 3 or more projects retrieve the department number and the number of employees with salaries greater than 40000 working in it.