Question: Consider the set of relations shown below. Students ( Roll _ number, Name, Date _ of _ birth ) Courses ( Course _ number, Course
Consider the set of relations shown below.
Students Rollnumber, Name, Dateofbirth
Courses Coursenumber, Coursename, Instructor Grades Roll number, Coursenumber, Grade
Now consider the query SELECT DISTINCT Name FROM Students, Courses, Grades
WHERE Students Rollnumber Grades Rollnumber
AND Courses Instructor 'Korth'
AND Courses Coursenumber Grades.Coursenumber
AND Grades.grade A
Which of the following sets is computed by the above
Select one:
a Names of students who have got an A grade in all courses
b Names of students who have got an A grade in all courses taught by Korth
c Names of students who have got an A grade in at least one course
d Names of students who have got an A grade in at least one of the courses taught by Korth
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
