Given the relational schemas:
ENROLL(SID,C_No,Section) – SID and C_No represent
student id number, course number respectively
TEACH(TID,C_No,Section) – TID represents teacher id
ADVISE(TID,SID) TID is the mentor of SID
PRE_REQ(C_No,PRE_C_No) – PRE_C_No is prerequisite
STUDENT(SID,S_Name) – S_Name is student name
Write the following queries in SQL.
a)List all students taking courses with Amit and
b)List all students taking at least one course that
their mentor teaches.
c)List those teachers who teach more than one section
of the same course.
d)List the courses that student Anindya can enroll
in, i.e., has passed the necessary prerequisite
courses but not the course itself.