(a) (b) List first and last names of all the employees who work in the department that is located in Houston and managed by an employee whose last name is Wong. Retrieve the last name and first name of all employees working for Administration department and who also work on the project(s) that is controlled by Research department.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question
Need Asap huhu ?????❤️
Q.3. Using the database schema shown below and relational algebra operators (ONLY).
design the following queries. Queries not written in RAO will not be graded and
assigned ZERO grade.
(a)
(b)
List first and last names of all the employees who work in the department
that is located in Houston and managed by an employee whose last name is
Wong.
Retrieve the last name and first name of all employees working for
Administration department and who also work on the project(s) that is
controlled by Research department.
You will need these symbols for queries ←, II, σ, ▷
EMPLOYEE
Fname Minit Lname Ssn Bdate Address Sex Salary Super_ssn Dno
DEPARTMENT
Dname Dnumber Mgr_ssn Mgr_start_date
DEPT_LOCATIONS
Dnumber Dlocation
PROJECT
Pname Pnumber Plocation Dnum
WORKS ON
Essn Pno Hours
DEPENDENT
Essn Dependent name Sex Bdate Relationship
Transcribed Image Text:Q.3. Using the database schema shown below and relational algebra operators (ONLY). design the following queries. Queries not written in RAO will not be graded and assigned ZERO grade. (a) (b) List first and last names of all the employees who work in the department that is located in Houston and managed by an employee whose last name is Wong. Retrieve the last name and first name of all employees working for Administration department and who also work on the project(s) that is controlled by Research department. You will need these symbols for queries ←, II, σ, ▷ EMPLOYEE Fname Minit Lname Ssn Bdate Address Sex Salary Super_ssn Dno DEPARTMENT Dname Dnumber Mgr_ssn Mgr_start_date DEPT_LOCATIONS Dnumber Dlocation PROJECT Pname Pnumber Plocation Dnum WORKS ON Essn Pno Hours DEPENDENT Essn Dependent name Sex Bdate Relationship
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Intelligent Machines
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education