and execute the following queries in relational algebra (RA) using the RA interpreter on the COMPANY database schema.List the names of all employees in department 5 who work more than 10 hours per week on the ProductX project.List the names of employees who are directly supervised by Franklin Wong.List the names of employees who work on at least one project in Dallas but the department has no location in Dallas.List the names of employees who work on every project.please answer them in a very clean and clear so I can read it and understand it Write precise and direct query. Referential integrity constraints displayed on the COMPANY relational database schema.ΕMPLOYEΕFname Minit Lname Ssn BdateAddressSex SalarySuper ssnDnoDEPARTMENTDname Dnumber Mgr_ssn Mgr_start_dateDEPT_LOCATIONSDnumberDlocationPROJECTPname Pnumber PlocationDnumWORKS_ONEssnPnoHoursDEPENDENTEssnDependent_nameSexBdateRelationship

Answered: Image /qna-images/answer/30f042d6-7edb-4df3-b85d-a5388dbb43ee.jpg

Answered: Referential integrity constraints…

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

See similar textbooks

Related questions

Concept explainers

Question

and execute the following queries in relational algebra (RA) using the RA interpreter on the COMPANY database schema.List the names of all employees in department 5 who work more than 10 hours per week on the ProductX project.

List the names of employees who are directly supervised by Franklin Wong.
List the names of employees who work on at least one project in Dallas but the department has no location in Dallas.
List the names of employees who work on every project.
please answer them in a very clean and clear so I can read it and understand it

Write precise and direct query.

Referential integrity constraints displayed on the COMPANY relational database schema.
ΕMPLOYEΕ
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

This is a popular solution!

Step by step

Solved in 2 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

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