Q29

MCQ2 marks, −0.67

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, playername 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 ' $M I^{\prime}$ ?

(A)

$\left\{p\right.$ . pname $\mid p \in$ players $\wedge \exists t\left(t \in\right.$ teams $\left.\left.\wedge p . t i d=t . t i d \wedge t . t n a m e=' M I^{\prime}\right)\right\}$

(B)

$\left\{p\right.$ . pname $\mid p \in$ teams $\wedge \exists t\left(t \in\right.$ players $\left.\left.\wedge p . t i d=t . t i d \wedge t . t n a m e=' M I^{\prime}\right)\right\}$

(C)

$\left\{p\right.$ . pname $\mid p \in$ players $\wedge \exists t\left(t \in\right.$ teams $\wedge t$ . tname $\left.\left.=' M I^{\prime}\right)\right\}$

(D)

$\left\{p\right.$ . pname $\mid p \in$ teams $\wedge \exists t\left(t \in\right.$ players $\wedge t$ . tname $\left.\left.=' M I^{\prime}\right)\right\}$

Loading…