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
Recommended book · affiliate linkDatabase System Concepts (Korth)Normalisation, SQL, transactions and indexing — the DBMS syllabus in one book.
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