This question has been answered
Question

database system assignment help will thumbs up for the correct answer ASAPConsider the following relations:

Course (cid:string, cname: string, dept: string)

Student (sid: integer, sname: string, gpa: string, dept: string)

Enroll (sid: integer, cid: string, grade: string)  

The meaning of these relations is straightforward and the keys are underlined. Write the following queries in SQL. 

a. Find the number of students not enrolled in any class.

b. List each student's name, along with the number of courses registered by that student.

c. Find name of students in 'Math' department who took all the courses offered by 'Computer Science' department.

Answered by Expert Tutors
Step-by-step explanation
4 Attachments
1.PNG
PNG
11.jpg
jpg
2.PNG
PNG
3.PNG
PNG
Course (cid:string, cname: string, dept: string) Student (sid: integer, sname: string, gpa: string, dept: string) Enroll (sid: integer, cid: string,...
Get unstuck

204,222 students got unstuck by Course
Hero in the last week

step by step solutions

Our Expert Tutors provide step by step solutions to help you excel in your courses