Schéma relationnel : Employee ( EmployeeID , FirstName, LastName, Email, Phone, HireDate, Salary, #DepartmentID) Department ( DepartmentID , DepartmentName, #ManagerID) Project ( ProjectID , ProjectName, StartDate, EndDate, Budget) Employee_Project ( #EmployeeID, #ProjectID , Role, AssignmentDate) Explication des relations : Employee ( EmployeeID ) est la clé primaire. Department ( DepartmentID ) est la clé primaire. Project ( ProjectID ) est la clé primaire. Employee_Project ( #EmployeeID, #ProjectID ) est une clé primaire composite (relation plusieurs-à-plusieurs entre Employee et Project). Employee(#DepartmentID) → Department(DepartmentID) : Un employé appartient à un département. Department(#ManagerID) → Employee(EmployeeID) : Un manager est un employé. Employee_Project(#EmployeeID) → Employee(EmployeeID) Employee_Project(#ProjectID) → Project(ProjectID) QUESTION Quelle requête affiche les départements ayant plus de 5 employés ? A) SELECT DepartmentID FROM Employee WHERE COUNT(*) > 5; B) SELECT DepartmentID, COUNT(*) FROM Employee GROUP BY DepartmentID HAVING COUNT(*) > 5; C) SELECT DepartmentID, COUNT(*) FROM Employee HAVING COUNT(*) > 5; D) SELECT DepartmentID FROM Employee GROUP BY DepartmentID;

Crowdly

Add to Chrome

✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.

Employee (EmployeeID, FirstName, LastName, Email, Phone, HireDate, Salary, #DepartmentID)
Department (DepartmentID, DepartmentName, #ManagerID)
Project (ProjectID, ProjectName, StartDate, EndDate, Budget)
Employee_Project (#EmployeeID, #ProjectID, Role, AssignmentDate)

Employee (EmployeeID) est la clé primaire.
Department (DepartmentID) est la clé primaire.
Project (ProjectID) est la clé primaire.
Employee_Project (#EmployeeID, #ProjectID) est une clé primaire composite (relation plusieurs-à-plusieurs entre Employee et Project).
Employee(#DepartmentID) → Department(DepartmentID) : Un employé appartient à un département.
Department(#ManagerID) → Employee(EmployeeID) : Un manager est un employé.
Employee_Project(#EmployeeID) → Employee(EmployeeID)
Employee_Project(#ProjectID) → Project(ProjectID)

Quelle requête affiche les départements ayant plus de 5 employés ?

A) SELECT DepartmentID FROM Employee WHERE COUNT(*) > 5;

B) SELECT DepartmentID, COUNT(*) FROM Employee GROUP BY DepartmentID HAVING COUNT(*) > 5;

C) SELECT DepartmentID, COUNT(*) FROM Employee HAVING COUNT(*) > 5;

D) SELECT DepartmentID FROM Employee GROUP BY DepartmentID;

Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!

Add to Chrome