GATE CS 2025 Set 1 — Question 39
Go beyond PYQs with Success TrackerAI-powered personalised practice and doubt support. Unlimited practice on eligible plans; AI usage limits apply.MCQ+2 / -0.67EasyTuple Relational CalculusRelational ModelDatabases
Databases → Relational Model → Tuple Relational Calculus
Last updated
Question
Consider two relations describing and in a sports league:
- : are team-id and team-name, respectively
- : and denote player-id, player name and the team-id of the player, respectively
Correct answer
(A) \ p.pname p ∈ players ∧ ∃ t (t ∈ teams ∧ p.tid = t.tid ∧ t.tname = 'MI') \
Solution
The goal is to find player names () for players belonging to a specific team ('MI').
- The result tuple variable must represent a record from the relation to access . Thus, is required. This eliminates (B) and (D).
- To filter by team name, we must join with using the common attribute . This is expressed as .
- The specific condition is .
- Combining these, we get: .
- Option (C) is incorrect because it lacks the join condition , which would result in a Cartesian product-like behavior where any player name is returned if any team has the name 'MI'.
Continue learning with Success Tracker
A step still unclear? Work through it with support
Use Success Tracker to ask about the reasoning, then try another GATE CS question to check your understanding.
AI-powered practice· Unlimited practice on eligible plans
- PYQs with solutions
- Attempt available previous-year questions, then compare your reasoning with the worked solution. Coverage varies by stream.
- Practice that adapts
- Choose a topic, work on weaker areas and bookmark questions to revisit. Your attempts feed your progress tracking.
- AI doubt support
- Ask follow-up questions about a step or concept while practising, instead of stopping at the final answer.
Unlimited practice is available on eligible plans. Free practice and AI usage have limits; check the current plan allowances before choosing.
This page stays readable without an account. AI responses can be wrong; check them against the solution and source material.
More questions on Relational Model
2026 Set 2 Q15In the context of DBMS, consider the two sets T and S given below. | T | S | |---|---| | I:…2026 Set 2 Q20Consider concurrent execution of two transactions and in a DBMS, both of which access a…2026 Set 1 Q30Let and be the attributes of a relation in a relational schema. Let…2026 Set 1 Q31In the context of relational database normalization, which of the following statements is/are true?2026 Set 2 Q42In the context of schema normalization in relational DBMS, consider a set F of functional…