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:

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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!