Question: students ( sid , name,age,gpa ) courses ( cid , deptid, description ) professors ( ssn , name,address,phone,deptid ) enrollment ( sid , cid,section,grade )
studentssidname,age,gpa
coursesciddeptid, description
professorsssnname,address,phone,deptid
enrollmentsidcid,section,grade cid makes reference to the courses table.
teachescidsection,ssn cid, section makes reference to the enrollment table
Provide SQL instructions for each of the following questions
Find the name of professors that work for the cs department.
Find those students sid enrolled in courses in the cs department.
List ssn and name of professors that work for the cs department, but are not teaching any cs
courses.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
