(Solved) : Consider University Database Schema Find Id S Professors Work Cs Ee Departments Set Opera Q35494439 . . . .

Consider the university database schema below.

Find the id’s of professors who work for the cs or eedepartments. with (i)set operations, (ii) without setoperations.

b) Find the id’s of professors who have a joint appointment inCS and EE departments (work for both departments).

c) Find the names of professors who have a joint appointment inCS and EE departments (work for both departments).

d) Find the id’s and names of CS professors or those who teach aCS course (use course code for string matching). (i) with setoperations, (ii) without set operations.

e) Find the student id’s and names of students who took allcourses that were taught