Crowdly
Add to Chrome
Questions Bank (1398906 total)
Relational Schema:
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)
Explanation of Relationships:
- Employee (EmployeeID) is the primary key.
- Department (DepartmentID) is the primary key.
- Project (ProjectID) is the primary key.
- Employee_Project (#EmployeeID, #ProjectID) is a composite primary key (many-to-many relationship between Employee and Project).
- Employee(#DepartmentID) REFERENCES Department(DepartmentID): An employee belongs to a department.
- Department(#ManagerID) REFERENCES Employee(EmployeeID): A manager is an employee.
- Employee_Project(#EmployeeID) REFERENCES Employee(EmployeeID)
- Employee_Project(#ProjectID) REFERENCES Project(ProjectID)
QUESTION
Which query returns the average salary of employees?A)SELECT AVG(Salary) WHERE Employee; B) SELECT MEAN(Salary) FROM Employee;C) SELECT AVG(Salary) FROM Employee GROUP BY Salary;D) SELECT AVG(Salary) FROM Employee;✅
❌
❌
❌
View this question
Geneva is not at her consumer equilibrium for movies and music downloads. Why?
❌
❌
❌
✅
❌
View this question
The relative price of beer to bacon is 2:1. If Bob's current consumption is at a level where MUbeer/MUbacon is 1:2, then to maximize total utility Bob must
0%
0%
0%
0%
0%
View this question
Advise Sarah how to maximize her utility if MUA = 8, MUB = 20, PA = 4 and PB = 5.
❌
❌
❌
❌
✅
View this question
L'ensemble est le plus grand ensemble contenu à la fois dans A et dans B
100%
0%
View this question
View this question
Si A et B sont deux ensembles d'une même famille , alors appartient aussi à la famille
100%
0%
View this question
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) RÉFÉRENCE Department(DepartmentID) : Un employé appartient à un département.
- Department(#ManagerID) RÉFÉRENCE Employee(EmployeeID) : Un manager de département est un employé.
- Employee_Project(#EmployeeID) RÉFÉRENCE Employee(EmployeeID) : Associe un employé à un projet.
- Employee_Project(#ProjectID) RÉFÉRENCE Project(ProjectID) : Associe un projet à un employé.
QUESTION
Quelle requête permet d'afficher les employés et le nom de leur département ?A)SELECT * FROM Employee INNER JOIN Department;B) SELECT Employee.FirstName, Employee.LastName, Department.DepartmentName FROM Employee JOIN Department ON Employee.DepartmentID = Department.DepartmentID;C) SELECT FirstName, LastName FROM Employee, Department;D) SELECT Employee.FirstName, Employee.LastName, Department.DepartmentName FROM Employee RIGHT JOIN Department;0%
0%
0%
0%
View this question
Parmi les relations définies sur suivantes cocher celles qui sont des relations d'équivalence
0%
0%
0%
0%
View this question
Si A et B sont deux parties d'un même ensemble E, les relations et sont équivalentes.
0%
0%
View this question