Neco 2017 Computer Studies Question 20
Practice objective / multiple choice question 20 from the 2017 Neco Computer Studies examination.
Consider the following relational schemas: Employee(EmpID, Name, DeptID, Salary) (EmpID is the primary key) Dept(DeptID, DeptName, ManagerID) (ManagerID references EmpID) The data are: Employee: 1, Alice, 10, 50000 2, Bob, 10, 60000 3, Carol, 20, 55000 4, Dave, 20, 65000 5, Eve, 30, 70000 Dept: 10, Sales, 1 20, R\\&D, 3 30, HR, 5 Write a relational algebra expression that returns the names of employees who earn more than the average salary of their department and also earn more than the salary of their department's manager. Then state the result of the expression for the data given.
Answer Options
About This Question
This is Neco 2017 Computer Studies Question 20. It is one of the objective questions from the 2017 Neco Computer Studies examination.
Difficulty level: Hard .
Master the Exam!
You've seen a preview, but there are thousands more questions plus AI tutor to break down complex solutions.