Skip to content
GATEiit

GATE CSE 2025 Session 1 Q39: TRC query for players of team MI

Question

Consider two relations describing teamsteams and playersplayers in a sports league:

• teams(tid,tname)teams(tid, tname): tidtid, tnametname are team-id and team-name, respectively • players(pid,pname,tid)players(pid, pname, tid): pidpid, pnamepname, and tidtid 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 tnametname as 'MI'?

Try it: multiple choice: exactly one correct option

Select one option
Wrong answer costs 2/3 mark in GATE.
Show answer and explanation

Answer: A (official GATE 2025 final answer key)

Concept used: Tuple relational calculus: range each tuple variable over the right relation and join on the common attribute.

First step: pp must range over players (it has pname) and tt over teams (it has tname); then check the query links them via tidtid.

Full step-by-step solution

Detailed working, common mistakes and linked mock tests will be available with a free GATEiit account. Log-in is coming soon.

Share this question

WhatsAppDownload image

Source: official GATE 2025 Session 1 CS question paper and final answer key, organised by IIT Roorkee. Question paper · Answer key

More Databases PYQs

PracticePractise Databases questions →Full paperAll GATE CSE 2025 Session 1 questions →