In the following tables ADVISOR and TAUGHTBYare foreign keyd…

In the following tables ADVISOR and TAUGHTBYare foreign keyd referring to the table PROFESSOR. ROLLNO and COURSEID in ENROLLMENT refer to tables with primary keys of the same name. STUDENT(ROLLNO, NAME, AGE, GENDER, ADDRESS, ADVISOR) COURSE(COURSEID, CNAME, TAUGHTBY, CREDITS) PROFESSOR(PROFID,PNAME, PHONE) ENROLLMENT(ROLLNO, COURSEID, GRADE) Write SQL expressions for the following queries: (i) Names of courses taught by ‘Prof. Raju. (ii) Names of students who have not enrolled for any course taught by ‘Prof. Ganapathy’. (iii) For each course, name’_tie r of students enrolled for the course.

Attachments:

Don't use plagiarized sources. Get Your Custom Essay on
In the following tables ADVISOR and TAUGHTBYare foreign keyd…
For as low as $7/Page
Order Essay

q1.JPG

Leave a Reply

Your email address will not be published. Required fields are marked *

*

*

*