Opening the paper…
Database Management Systems, End Term
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?
SELECT mentorNameFROM mentor MRWHERE NOT EXISTS (SELECT menteeIDFROM mentee MEWHERE ME.advisorID = MR.mentorIDAND ME.rating <>'BAD');Consider the following relational schema: **mentor**(<u>mentorID</u>, mentorName, department)\ **mentee**(<u>menteeID</u>, 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? SELECT mentorName FROM mentor MR WHERE NOT EXISTS (SELECT menteeID FROM mentee ME WHERE ME.advisorID = MR.mentorID AND ME.rating <>'BAD'); Consider a non-empty B+-tree of order 17. What are the maximum and minimum number of keys that can be placed in the root node? Given the following schema: **students**(studentID, firstName, lastName, admissionDate, deptID)\ **departments**(deptID, deptName, profID, buildingID) You want to display the first names and admission dates of all first admissions in their respective departments in the building having ID=1001. Which of the following queries will display the correct result?