Sail E0 Webinar
Question
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.snameFROM Students as S, Registration as RWHERE 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)}
Options:
A .  I, II, III and IV
B .  I, II and III only
C .  I, II and IV only
D .  II, III and IV only
Answer: Option A


-NA-



Was this answer helpful ?
Next Question

Submit Solution

Your email address will not be published. Required fields are marked *

Latest Videos

Latest Test Papers