Consider the following relational schema. $\text{Students}(\underline{\text{rollno: integer}}, \text{ sname: string})$ $\text{Courses}(\underline{\text{courseno: integer}}, \text{ cname: string})$ $\text{Registration}(\underline{\text{rollno: integer}}, \underline{\text{courseno: integer}}, \text{ percent: real})$ Which of the following queries are equivalent to this query in English? “Find the distinct names of all students who score more than 90% in the course numbered 107” (I) SELECT DISTINCT S.snameFROM Students as S, Registration as RWHERE R.rollno=S.rollno AND R.courseno=107 AND R.percent >90 (II) $\Pi_{\text{sname}}(\sigma_{\text{courseno}=107 \wedge \text{percent}>90} (\text{Registration} \bowtie \text{Students}))$ (III) $\{ \text{T} \mid \exists \text{S} \in \text{Students}, \exists \text{R} \in \text{Registration} \ ( \text{S.rollno}=\text{R.rollno} \wedge \text{R.courseno}=107 \wedge \text{R.percent}>90 \wedge \text{T.sname}=\text{S.sname})\}$ (IV) $\{ \langle \text{S}_\text{N} \rangle \mid \exists \text{S}_\text{R} \exists \text{R}_\text{P} \ ( \langle \text{S}_\text{R}, \text{S}_\text{N} \rangle \in \text{Students} \wedge \langle \text{S}_\text{R}, 107, \text{R}_\text{P} \rangle \in \text{Registration} \wedge \text{R}_\text{P} > 90)\}$

Consider the following relational schema. Students( rollno: integer, sname: string) Courses( courseno: integer, cname: string) Registration( rollno: integer, courseno: integer, percent: real) Which of the following queries are equivalent to this query in English? “Find the distinct names of all students who score more than 90% in the course numbered 107” (I) SELECT DISTINCT S.sname FROM Students as S, Registration as R WHERE R.rollno=S.rollno AND R.courseno=107 AND R.percent >90 (II) sname( courseno=107 percent>90 (Registration Students)) (III) \ T S Students, R Registration \ ( S.rollno=R.rollno R.courseno=107 R.percent>90 T.sname=S.sname)\ (IV) \ SN SR RP \ ( SR, SN Students SR, 107, RP Registration RP > 90)\\

Topic-wise GATE CS PYQs with verified steps