Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started