Consider a database with the following three relations: range of s is CREDITS…

PYQ GATE 1989

Consider a database with the following three relations:

range of s is CREDITS
range of t is OFFERS
retrieve into LIST 1 (1=s. STUDENT)
where s.COURSE=t.COURSE and
t.TEACHER="Dr.X"
retrieve into LIST 2 (1=s.STUDENT)
where s.COURSE =t.COURSE and
t.TEACHER ="Dr.Y"
retrieve into LIST3 (1=STUDENT)
where s.course =t.COURSE and
t.TEACHER ="Dr.Z"
range to e1 is LIST1
range of e2 is LIST2
range of e3 is LIST3
retrieve(E1.I)
where e1.I=e2.I and
where e1.I=e3.I

CREDITS (STUDENT; COURSE)

OFFERS (TEACHER; COURSE)

BELONGS (TEACHER; DEPARTMENT)

Given below is a code in query language QUEL. Describe in one English sentence the query posed by the given QUEL program.

Sign up free to check your answer

Sign up free

Explore the full course: Zero To Hero

Loading lesson…