Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Write the operations as a single relational algebra expression and the results of the queries for the following questions: Q2. For every project located in

Write the operations as a single relational algebra expression and the results of the queries for the following questions: Q2. For every project located in Stafford, list the project number, the controlling department number, and the department managers last name, address, and birth date. EMPLOYEE(Fname,Lname,Ssn,Dno) DEPARTMENT(Dname,Dnumber,Mgr_ssn,Mgr_start_date) PROJECT(Pname, Pnumber, Plocation, Dnum) Q3. Find the names of employees who work on all the projects controlled by department number 5. EMPLOYEE(Fname,Lname,Ssn,Dno) WORKS_ON(Essn, Pno, Hours) PROJECT(Pname, Pnumber, Plocation, Dnum) Q4. Make a list of project numbers for projects that involve an employee whose last name is Smith, either as a worker or as a manager of the department that control the projects. EMPLOYEE(Fname,Lname,Ssn,Dno) DEPARTMENT(Dname,Dnumber,Mgr_ssn,Mgr_start_date) PROJECT(Pname, Pnumber, Plocation, Dnum) Q6. Retrieve the names of employees who have no dependents. EMPLOYEE(Fname,Lname,Ssn,Dno) DEPENDENT(Essn, Dependent_name, Sex, Bdate, Relationship)

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

XML Data Management Native XML And XML Enabled Database Systems

Authors: Akmal Chaudhri, Awais Rashid, Roberto Zicari, John Fuller

1st Edition

ISBN: 0201844524, 978-0201844528

More Books

Students also viewed these Databases questions