Question

Given the relational schema :

ENROL (ENo, C_Id, Class) - ENo represents student number
TEACH (Prof, C_Id, Class) – C_Id represents course number
ADVISE (Prof, ENo) - Prof is project guide of ENo (Student’s enrol_no)
PRE_REQ (C_Id, Pre_C_Id) - Pre_C_Id is prerequisite course
GRADES (ENo, C_Id, Grade, Year)
STUDENT (ENo, SName) - SName is student name

Write SQL statements for the following :

(i) List all students whose project guide is Prof.Murthy.
(ii) List the grade for the student with ENo=1234
(iii) List those professors who teach more than one class.
(iv) List all the student names and ENo’s who got Grade A in the year 2018 in C_Id= 100.
(v) List all the students who has taken the pre-requisite course Pre_C_Id= 001.

Answer 1

Answer:

What is your question I don't understand