Consider the following relational schema. Students(rollno: integer, sname:…
PYQ GATE 2013
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)}
- A.
I, II, III and IV
- B.
I, II and III only
- C.
I, II and IV only
- D.
II, III and IV only
Attempted by 157 students.
Sign up free to check your answer
Sign up freeLoading lesson…

