The following relations are used to store data about students, courses,…

PYQ GATE 1993Modified — slightly modified from the official paper; see the solution

The following relations are used to store data about students, courses, enrollment of students in courses and teachers of courses. Attributes for primary key in each relation are marked by “*”.

Students (rollno*, sname, saddr)

courses (cno*, cname)

enroll(rollno*, cno*, grade)

teach(tno*,tname,cno*)

(cno is course number, cname is course name, tno is teacher number, tname is teacher name, sname is student name, etc.)

Write a SQL query for retrieving roll number and name of students who got A grade in at least one course taught by teacher named Ramesh for the above relational database.

Attempted by 1 students.

Sign up free to check your answer

Sign up free

Explore the full course: Zero To Hero

Loading lesson…