6. For each project on which more than two employees worked, list the project nu

Question

6. For each project on which more than two employees worked, list the project number, project name and the number of employees who work on that project.

The following tables form part of a database held in a Relational Database Management System. Use this schema to answer queries 3, 4, 5, & 6. Employee (emplD, fNo Name, address, DOB, sex, position, deptNo) ame, Department (deptNo, deptName, mgrEmpID) Project projNo, projName, deptNo) Works On emplD, projNo, hours Worked where Employee contains employee details and emplD is the key. Department contains department details and deptNo is the key. mgrEmplD identifies the employee who is the manager of the department. There is only one manager for each department. Project contains details of the projects in each department and the key is projNo (no two departments can run the same project). and Works On contains details of the hours worked by employees on each project, and em projNo form the key.

Explanation / Answer

Query : select p.projNo,projName,count(*) from Project p,WorksOn w where p.projNo=w.projNo group by p.projNo,p.projName having count(*)>2;

Related Questions

Navigate

• Browse (All)
• Browse 6
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.