Consider the following relational schema.

  • Students(rollno: integer, sname: string)
  • Courses(courseno: integer, cname: string)
  • Registration(rollno: integer, courseno: integer, percent: real)

Query : “Find the distinct names of all students who score more than 90% in the course numbered 107” 

How's the below query returning correct solution ??


When i write  "{T |  " --> should'nt we define T as which relation tuple (like ∃T∈ Students) it is ..?? like we did for S and R in above query.


Did not found what you are looking for, Ask your doubt or Help by your contribution

Enter your search keyword:

Search form


Here is a chance to join biggest community of technical Students,
Tutors with FREE learning resources and so much more.
It takes less then 60 seconds.