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
OR
PayPal Gateway not configured
OR
PayPal Gateway not configured