I'll keep it nice and short and simply link to the ERD:
Users can be assigned a role, one of those is student. So for the sake of this, Students are the same as Users!
A Student can be enrolled in many OfferedUnits. A Student can also be in Many Teams and a Team can have Many Students.
The issue I am having is this: Should the Many-to-Many relationship that allows a Student to be in many teams and a Team to have many students be between the Users Table and the Teams Table or the Enrollment Table and the Teams table?
The argument for the Enrollment option is as such: You will only be able to assign a Team to Enrolled students. That's the only reason I can think of doing it that way.
Otherwise, it logically doesn't make sense to connect Enrollment to Teams, because it's the STUDENT who is in a Team, not their Enrollment.
What do you think?