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 10 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 10 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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!