Consider the following relational schema: Course (courseName unique, department,

Question

Consider the following relational schema: Course (courseName unique, department, instrID) Instructor (instrID unique, office) Student (studentID unique, major) Enroll (studentID, courseName, unique (studentID, courseName)) Suppose there are five types of queries commonly asked on this schema: Given a course name, find the department offering that course. List all studentsIDs together with all of the departmentsthey are taking courses in. Given a studentID, find the names of all courses the students is enrolled in. List the offices of instructors teaching at leat one course. Given a major, return the studentIDs of students in that major. Which of the following indexes could NOT be useful in speeding up execution of one or more of the above queries? Index on Enroll.courseName Index on Enroll.studentID Index on Course.instrID Index on Instructor.office

Explanation / Answer

Index OnEnroll.studentID

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.