✅ 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(eId, Name) Brand(bId, bName)Own(eId, bId)
SELECT O1.eId FROM Own O1 WHERE NOT EXISTS ( SELECT B.bId FROM Brand B WHERE NOT EXISTS ( SELECT * FROM Own O2 WHERE O2.eId = O1.eId AND O2.bId = B.bId ) );
Which of the following Relational Algebra expressions correctly represents this query?