Crowdly
Додати до Chrome
Schéma relationnel : Employee ( EmployeeID , FirstName, LastName, Email, Phone...
✅ Перевірена відповідь на це питання доступна нижче. Наші рішення, перевірені спільнотою, допомагають краще зрозуміти матеріал.
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 employés qui ne sont pas dans le département 3 ou 5 ?A)SELECT * FROM Employee WHERE DepartmentID NOT IN (3,5);B) SELECT * FROM Employee WHERE DepartmentID != (3,5);C) SELECT * FROM Employee WHERE DepartmentID <> (3,5);D) SELECT * FROM Employee WHERE DepartmentID NOT ANY (3,5);❌
✅
❌
❌