GATE CS 2025 (Forenoon) — Question 39

Database Management Systems (DBMS)Relational Models, Relational Algebra, Tuple CalculusMCQ2 marks · −2/3 if wrongMedium

Consider two relations describing teams and players in a sports league: • teams(tid, tname): tid, tname are team-id and team-name, respectively. • players(pid, pname, tid): pid, pname, and tid denote player-id, player-name and the team-id of the player, respectively. Which ONE of the following tuple relational calculus queries returns the name of the players who play for the team having tname as 'MI'?
  1. A
    \( \{p.\text{pname} \mid p \in \text{players} \land \exists t (t \in \text{teams} \land p.\text{tid} = t.\text{tid} \land t.\text{tname} = \text{'MI'})\} \)
  2. B
    \( \{p.\text{pname} \mid p \in \text{teams} \land \exists t (t \in \text{players} \land p.\text{tid} = t.\text{tid} \land t.\text{tname} = \text{'MI'})\} \)
  3. C
    \( \{p.\text{pname} \mid p \in \text{players} \land \exists t (t \in \text{teams} \land t.\text{tname} = \text{'MI'})\} \)
  4. D
    \( \{p.\text{pname} \mid p \in \text{teams} \land \exists t (t \in \text{players} \land t.\text{tname} = \text{'MI'})\} \)
Practise the full 2025-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