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 8 times
Refer To The Company Schema Below To Solve The Queries Employee Fname Minit Lname San Aaaa Department Dname Dnumber Mgr 2 (24.46 KiB) Viewed 8 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 Question 4) (5 points) Write the following queries in Relational Calculus 1) Retrieve the names of projects having employees with salaries greater than 40000. 2) Retrieve the names of employees who work in department 4 and all his/her dependents are females
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!