Formulate the following queries in: Relational Algebra.
The following tables form part of a database held in an RDBMS:
Employee (empNo, fName, lName, address, DOB, sex, position, salary, deptNo)
Department (deptNo, deptName, mgrEmpNo)
Project (projNo, projName, deptNo)
WorksOn (empNo, projNo, dateWorked, hoursWorked)
where
- Employee contains employee details and empNo is the key.
- Department contains department details and deptNo is the key. mgrEmpNo identifies the employee who is the manager of the department. There is only one manager foreach department.
- Project contains details of the projects in each department and the key is projNo (notwo departments can run the same project).
- WorksOn contains details of the hours worked by employees on each project, and empNo/ projNo/dateWorked form the key.
Formulate the following queries in: Relational Algebra.
- List all the details of employees who are female and born after 1990.
- List employee numbers and names of all employees who are not managers and are paid more than $1500.
- Produce a list of the names and addresses of all employees who work for the IT department.