Consider two relations describing \(π‘‘π‘’π‘Žπ‘šπ‘  \) and \(π‘π‘™π‘Žπ‘¦π‘’π‘Ÿπ‘  \) in a…

GATE Β· 2025 Β· CS Β· Set 1 Β· Computer Science & IT

Consider two relations describingΒ π‘‘π‘’π‘Žπ‘šπ‘ π‘‘π‘’π‘Žπ‘šπ‘  andΒ π‘π‘™π‘Žπ‘¦π‘’π‘Ÿπ‘ π‘π‘™π‘Žπ‘¦π‘’π‘Ÿπ‘  in a sports league:

β€’Β π‘‘π‘’π‘Žπ‘šπ‘ (𝑑𝑖𝑑,π‘‘π‘›π‘Žπ‘šπ‘’):𝑑𝑖𝑑,π‘‘π‘›π‘Žπ‘šeπ‘‘π‘’π‘Žπ‘šπ‘ (𝑑𝑖𝑑,π‘‘π‘›π‘Žπ‘šπ‘’): 𝑑𝑖𝑑, π‘‘π‘›π‘Žπ‘še are team-id and team-name, respectively

β€’ π‘π‘™π‘Žπ‘¦π‘’π‘Ÿπ‘ (𝑝𝑖𝑑,π‘π‘›π‘Žπ‘šπ‘’,𝑑𝑖𝑑):𝑝𝑖𝑑,π‘π‘›π‘Žπ‘šπ‘’π‘π‘™π‘Žπ‘¦π‘’π‘Ÿπ‘ (𝑝𝑖𝑑, π‘π‘›π‘Žπ‘šπ‘’,𝑑𝑖𝑑): 𝑝𝑖𝑑, π‘π‘›π‘Žπ‘šπ‘’, and 𝑑𝑖𝑑𝑑𝑖𝑑 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 π‘‘π‘›π‘Žπ‘šπ‘’ as ′𝑀𝐼𝑀𝐼′?

Attempted by 152 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…