Databases · Relational Model and SQL
Official IIT answer key · IIT Guwahati · Audited Aug 2026
GATE CSE 2025 Set 1 Q39 · MCQ · 2 marks
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
Key concept
No account needed
Sit 5 related Relational Model and SQLPYQs as a guest. We'll score the set and show which traps cost marks — sign in only if you want to save the run.
Topic notes
GATE tests the relational model across three interrelated formalisms: Relational Algebra (RA), Relational Calculus (TRC/DRC), and SQL. Questions evaluate core semantic equivalences, translation between declarative calculi and algebraic operators, table instance tracing (such as joins, group-by aggregations, and division), and corner cases like SQL three-valued logic, duplicate preservation, and safe TRC expressions.
Full Relational Model and SQL guide →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'?
Topic-wise GATE CS PYQs with verified steps
Independent practice explanation verified by the GateAI team. GATE is conducted by the IITs; question text follows the official paper.
