How to get student names not registered for any classes?

Courses
1

I’m trying to figure out how to get the names of students who aren’t taking any classes. Here’s what our database looks like:

Students: snum, sname, major, standing, age, gpa
Faculty: fid, fname, deptid
Courses: cnum, cname, course_level, credits
Offerings: onum, cnum, day, starttime, endtime, room, max_occupancy, fid
Enrolled: snum, onum

I know I can get the student numbers (snum) of those not enrolled like this:

π snum Students - π snum Enrolled

But I’m stuck on how to get their actual names (sname) instead of just their numbers. Any ideas on how to do this? I’m new to relational algebra, so a simple explanation would be super helpful. Thanks!

2

Hey there Luke87! :wave:

I totally get your confusion with relational algebra. It can be a bit tricky at first, right?

Have you considered using a left outer join? It might be a neat way to tackle this. Something like:

π sname (Students ⟕ Enrolled)

Then you could filter for null values in the Enrolled attributes. This way, you’re keeping all students but only those without a match in Enrolled.

What do you think about this approach? Have you tried anything similar yet?

I’m curious - what made you interested in this particular problem? Are you working on a school project or is this for something else?

Keep us posted on how it goes! :blush:

3

hey luke, i think u can use a join operation to get the names. try something like this:

π sname (Students ⋉ (π snum Students - π snum Enrolled))

this should give u the names of students not in any classes. hope it helps!

4

Your approach is on the right track, Luke. To get the student names, you’ll need to combine your initial set difference with a join operation. Here’s how you can do it:

π sname (Students ⨝ (π snum Students - π snum Enrolled))

This operation first finds the student numbers not in Enrolled, then joins that result with the Students table to retrieve the corresponding names. The outer projection (π sname) ensures you only get the names in your final output.

Remember, the natural join (⨝) automatically matches on the common attribute (snum in this case). This method should give you a list of names for students not registered in any classes. Let me know if you need any clarification on this!