I have these following tables: lab6_student, lab6_course, lab6_reg These are the

Question

I have these following tables: lab6_student, lab6_course, lab6_reg

These are the attributes:

lab6_student(SID, SNAME, GPA, MAJOR)
lab6_course(CNO, CNAME, CREDITS, DEPT)
lab6_reg(SID CNO GRADE)

Here are the following questions:

1. Find courses which had no enrollments (i.e., nobody registered for the course)

2. Find students who did not take any course offered by the Bus department

3. Find students who did not take any 4 credit hour course

4. Find courses where every student got an A

5. Find students who got an A in all courses they took

6. Find courses where every student has a GPA over 3.5

7. Find courses where every student getting an A has a GPA over 3.5

8. Find students who took every course offered by the Bus Department

9. Find students who got a B in every course offered by the Bus department

10. Find the pairs of students who took exactly the same set of courses

11. Find Courses where more than half the students got an A

Explanation / Answer

1. select distinct cno from course minus select distinct cno from reg

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---