GATE CS 2022 (Forenoon) — Question 25

Database Management Systems (DBMS)Relational Models, Relational Algebra, Tuple CalculusMSQ1 markMedium

Consider the following three relations in a relational database. Employee (\underline{eId}, Name), Brand (\underline{bId}, bName), Own(\underline{eId, bId}) Which of the following relational algebra expressions return the set of eIds who own all the brands?
  1. A
    \(\pi_{eId} (\pi_{eId, bId} (\text{Own}) / \pi_{bId} (\text{Brand}))\)
  2. B
    \(\pi_{eId} (\text{Own}) - \pi_{eId} ((\pi_{eId} (\text{Own}) \times \pi_{bId} (\text{Brand})) - \pi_{eId, bId} (\text{Own}))\)
  3. C
    \(\pi_{eId} (\pi_{eId, bId} (\text{Own}) / \pi_{bId} (\text{Own}))\)
  4. D
    \(\pi_{eId} ((\pi_{eId} (\text{Own}) \times \pi_{bId} (\text{Own}) / \pi_{bId} (\text{Brand}))\)
Practise the full 2022-FN paper
Challenge a friend: WhatsApp Telegram
From RENYXERAWhat rank do your marks get?GATE score, likely All-India Rank and qualifying marks for your category.
Practise more on Relational Models, Relational Algebra, Tuple CalculusTimed, in the real exam interface · free to start

A GATE question every morning

One real past-paper question every morning for your branch, answer hidden until you tap. Free on Telegram.

Join
Stuck? Ask in the student group