The Gateway to Computer Science Excellence

0 votes

Consider a database with the following three relations:

- 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.

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

- All categories
- General Aptitude 1.9k
- Engineering Mathematics 7.5k
- Digital Logic 2.9k
- Programming and DS 4.9k
- Algorithms 4.4k
- Theory of Computation 6.2k
- Compiler Design 2.1k
- Databases 4.1k
- CO and Architecture 3.4k
- Computer Networks 4.2k
- Non GATE 1.4k
- Others 1.4k
- Admissions 595
- Exam Queries 573
- Tier 1 Placement Questions 23
- Job Queries 72
- Projects 18

50,737 questions

57,258 answers

198,086 comments

104,735 users