Formulate the following queries in Structured Query Language SQL
- Produce a list of the names of all employees who work on the Biometric project.
- Produce a report of all projects under the IT department.
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 Structured Query Language SQL
- Produce a list of the names of all employees who work on the Biometric project.
- Produce a report of all projects under the IT department.