Transformation Example:Pushing Selections Query:Find the names of all instructors in the Music department,along with the titles of the courses that they teach Πname,te(dept name=1 Music” (instructor凶(teaches凶Πcourse_id,tite(course)》 Transformation using rule 7a. ☐name,tte(dept name=Music"(instructor))凶 (teaches凶IΠcourse_ia,tite(course)》 Performing the selection as early as possible reduces the size of the relation to be joined. Database System Concepts-6th Edition 1.15 @Silberschatz,Korth and SudarshanDatabase System Concepts - 6 1.15 ©Silberschatz, Korth and Sudarshan th Edition Transformation Example: Pushing Selections Query: Find the names of all instructors in the Music department, along with the titles of the courses that they teach name, title(dept_name= “Music” (instructor (teaches course_id, title (course)))) Transformation using rule 7a. name, title((dept_name= “Music” (instructor)) (teaches course_id, title (course))) Performing the selection as early as possible reduces the size of the relation to be joined