Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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:

image text in transcribedimage text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Learning MySQL Get A Handle On Your Data

Authors: Seyed M M Tahaghoghi

1st Edition

0596529465, 9780596529468

More Books

Students also viewed these Databases questions

Question

6. What are some of the advantages and disadvantages of ESOPs?

Answered: 1 week ago

Question

2. Employees and managers participate in development of the system.

Answered: 1 week ago