Question-38

DBMS

Consider the set of relations shown below and the SQL query that follows.

Students: (Roll_number, Name, Date_of_birth)
Courses: (Course_number, Course_name, Instructor)
Grades: (Roll_number, Course_number, Grade)

SELECT DISTINCT Name
FROM Students, Courses, Grades
WHERE Students.Roll_number=Grades.Roll_number
AND Courses.Instructor = 'Korth'
AND Courses.Course_number = Grades.Course_number
AND Grades.Grade = 'A'

Which of the following sets is computed by the above query?