Solved

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

Question 9

Essay

The following tables form part of a database held in a Relational Database Management System:
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. 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.

Correct Answer:

verifed

Verified

(1) blured image (2) blured image ...

View Answer

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions