Assume the following below given tables and answer the questions. Teacher (teacher_ID, teacher_name, teacher_dept, teacher_salary) Teaches...

  

Transcribed Image Text:

Assume the following below given tables and answer the questions. Teacher (teacher_ID, teacher_name, teacher_dept, teacher_salary) Teaches (teacher_ID, course_id, sec_id, semester, year) Course (course_id, course_title, dept_name, course_credits) a) Query 1: write a relational algebra query to find the names of all teachers in the IT department, along with the course titles of the courses that they teach. b) Query 2: write a relational algebra query to find the names of all instructors in the IT department who have taught a course in 2020, along with the titles of the courses that they taught. Assume the following below given tables and answer the questions. Teacher (teacher_ID, teacher_name, teacher_dept, teacher_salary) Teaches (teacher_ID, course_id, sec_id, semester, year) Course (course_id, course_title, dept_name, course_credits) a) Query 1: write a relational algebra query to find the names of all teachers in the IT department, along with the course titles of the courses that they teach. b) Query 2: write a relational algebra query to find the names of all instructors in the IT department who have taught a course in 2020, along with the titles of the courses that they taught.