(1) Retrieve the names (fpame.Jname) of employees who work more than 11 hours per week on the 'TSU' project. (“TSU" is project name.) (2) Retrieve the names (fpame, Iname) of all employees who work on at least one project. (3) Retrieve the locations of “EEE" department. (“EEE" is department name).

A Guide to SQL
9th Edition
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Philip J. Pratt
Chapter2: Database Design Fundamentals
Section: Chapter Questions
Problem 11RQ
icon
Related questions
Question
Specify the following queries on the database schema shown in the following figure,
using the operations of the relational algebra. The homework submission must be typed.
Using SQL to solve the queries will get a Zero. Submit a PDF file to Canvas.
EMPLOYEE
FNAME
MINIT
LNAME
SSN
BDATE
ADDRESS
SEX
SALARY
SUPERSSN
DNO
DEPARTMENT
DNAME
DNUMBER
MGRSSN
MGRSTARTDATE
DEPT_LOCATIONS
DNUMBER
DLOCATION
PROJECT
PNAME
PNUMBER
PLOCATION
DNUM
WORKS_ON
ESSN
PNO
HOURS
DEPENDENT
ESSN
DEPENDENT NAME
SEX
BDATE
RELATIONSHIP
(1) Retrieve the names (fpame.Jname) of employees who work more than 11 hours per
week on the 'TSU' project. (“TSU" is project name.)
(2) Retrieve the names (fpame, Iname) of all employees who work on at least one project.
(3) Retrieve the locations of “EEE" department. (“EEE" is department name).
(4) Find the name (fpamelname) of the direct supervisor of "Mike Smith". (“Mike
Smith" is an employee). Please pay attention that this question is about supervisor, not
manager.
Transcribed Image Text:Specify the following queries on the database schema shown in the following figure, using the operations of the relational algebra. The homework submission must be typed. Using SQL to solve the queries will get a Zero. Submit a PDF file to Canvas. EMPLOYEE FNAME MINIT LNAME SSN BDATE ADDRESS SEX SALARY SUPERSSN DNO DEPARTMENT DNAME DNUMBER MGRSSN MGRSTARTDATE DEPT_LOCATIONS DNUMBER DLOCATION PROJECT PNAME PNUMBER PLOCATION DNUM WORKS_ON ESSN PNO HOURS DEPENDENT ESSN DEPENDENT NAME SEX BDATE RELATIONSHIP (1) Retrieve the names (fpame.Jname) of employees who work more than 11 hours per week on the 'TSU' project. (“TSU" is project name.) (2) Retrieve the names (fpame, Iname) of all employees who work on at least one project. (3) Retrieve the locations of “EEE" department. (“EEE" is department name). (4) Find the name (fpamelname) of the direct supervisor of "Mike Smith". (“Mike Smith" is an employee). Please pay attention that this question is about supervisor, not manager.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
A Guide to SQL
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr