Answer to Question #145162 in Databases | SQL | Oracle | MS Access for Ankita Sonawane

Question

Consider the following relation En roll (S-no, Course-no, Section)
Teach (Prot, Course-no, Section)
Advise (Port, S-no)
Pre-Req (Course-no, Precourse-no)
Grades (S-no, Course-no, grade, year)
Write down queries expressed in SQL

1) List all students taking course with smith or Jones

2) Find all students taking at least one course that their adviser teaches

3) List those professor who teach more than one section of the same course

4)Find all students whose course number is ‘101’

Answer 1

Dear Ankita Sonawane, your question requires a lot of work, which neither of our experts is ready to perform for free. We advise you to convert it to a fully qualified order and we will try to help you. Please click the link below to proceed: Submit order