Question 1: Consider the following relational schema: mentor(<u>mento…

Consider the following relational schema:

mentor(mentorID, mentorName, department)
mentee(menteeID, menteeName, advisorID, rating)

advisorID is a foreign key referring to mentorID of the mentor relation. Assume that each mentor advises at least one mentee. Every mentee is required to give a rating to their mentor for feedback purposes. What does the following query return?

1SELECT mentorName
2FROM mentor MR
3WHERE NOT EXISTS (SELECT menteeID
4FROM mentee ME
5WHERE ME.advisorID = MR.mentorID
6AND ME.rating <>'BAD');