I have 3 tables that are currently defined as:
Is this the best way, or should I use an associative table?
I put the relationships backwards, 1 group can contain many users and many students. There is no other relationship between the user and the student other than the group. This is for a tracking program where the user or users are taking a student or group of students through a check-in procedure.