Crowdly
Add to Chrome
Schéma relationnel : Employee ( EmployeeID , FirstName, LastName, Email, Phone...
✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.
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 retourne le salaire moyen des employés ?A) SELECT AVG(Salary) FROM Employee;B) SELECT MEAN(Salary) FROM Employee;C) SELECT AVG(Salary) FROM Employee GROUP BY Salary;D) SELECT AVG(Salary) WHERE Employee HAVING Salary
❌
✅
❌
❌