Crowdly

Add to Chrome

Given the following SQL query: employee(empid, empName, empAge) dependent(de...

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

Given the following SQL query:

employee(empid, empName, empAge)

dependent(depId, eId , depName, depAge)

SELECT empId

FROM employee

WHERE empId NOT IN (

SELECT e.empId

FROM employee e

JOIN dependent d ON e.empId = d.eId

WHERE e.empAge <= d.depAge

);

Which of the following Relational Algebra expressions correctly represents this query?

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

Add to Chrome