The following tables form part of a database held in a Relational Database Management System:
Formulate the following queries in relational algebra, tuple relational calculus, and domain relational calculus.
(1) List all employees.
(2) List all the details of employees who are female.
(3) List the names and addresses of all employees who are Managers.
(4) Produce a list of the names and addresses of all employees who work for the 'IT' department.
(5) Produce a list of the names of all employees who work on the 'SCCS' project.

Question

The following tables form part of a database held in a Relational Database Management System:
  Formulate the following queries in relational algebra, tuple relational calculus, and domain relational calculus.
(1) List all employees.
(2) List all the details of employees who are female.
(3) List the names and addresses of all employees who are Managers. 
(4) Produce a list of the names and addresses of all employees who work for the 'IT' department.
(5) Produce a list of the names of all employees who work on the 'SCCS' project.

Quizplus · Accepted Answer

The Answer of The following tables form part of a database held in a Relational Database Management System:
  Formulate the following queries in relational algebra, tuple relational calculus, and domain relational calculus.
(1) List all employees.
(2) List all the details of employees who are female.
(3) List the names and addresses of all employees who are Managers. 
(4) Produce a list of the names and addresses of all employees who work for the 'IT' department.
(5) Produce a list of the names of all employees who work on the 'SCCS' project.

The Following Tables Form Part of a Database Held in a Relational