Question: Formulate Relational Algebra queries: Use the schema from Case Company to formulate your queries EMPLOYEE Fname Minit Lname Ssn Bdate Address Sex Salary Superssn Dno
Formulate Relational Algebra queries:


Use the schema from Case Company to formulate your queries EMPLOYEE Fname Minit Lname Ssn Bdate Address Sex Salary Superssn Dno DEPARTMENT DnameDnumber Mgr_ssn Mgr_start_date DEPT LOCATIONS DnumberDlocation PROJECT Pname Pnumber Plocation Dnum WORKS ON Essn Pno Hours DEPENDENT Essn Dependent_nameS Bdate Relationship Query 5 Retrieve the names of all employees who have two or more dependents Query 6 Retrieve the names of employees who have no dependents. Query 7 List the names of managers who have at least one dependent. Query 8 For each employee, retrieve the employee's first and last name and the first and last name of his or her immediate supervisor Query 9 Retrieve all employee SSNs Query 10 Retrieve all combinations of SSN and DEPARTMENT NAME Query 11 Retrieve the salary of every employee Query lla' Retrieve the distinct salary values Query 12 Retrieve all employees whose address is in Houston, Texas Query 13 Show the resulting salaries if every employee working on the ProductX project is given a 10% raise Query 14 Retrieve all employees in department 5 whose salary is between $30,000 and $40,000
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
