Consider the following three relations in a relational database. Employee(eId…
GATE · 2022 · CS · Computer Science & IT
Consider the following three relations in a relational database.
Employee(eId , Name ), Brand (bId , bName ), Own( eId ,bId )
Which of the following relational algebra expressions return the set of eIds who own all the brands?
- A.
πeId (πeId,bId(Own) / πbId (Brand))
- B.
πeId(Own) – πeId((πeId(Own) × πbId(Brand)) – πeId, bId(Own))
- C.
πeId (πeId, bId(Own) / πbId(Own))
- D.
πeId((πeId(Own) × πbId(Own) / πbId(Brand))
Attempted by 155 students.
Sign up free to check your answer
Sign up freeLoading lesson…