I have a table called “Students” and a table called “Class Instances” and want to create a table called Enrollments to marry up the students enrolled in the class. A class instance can have many students and students can be enrolled in many class instances.
The "Enrollments" table would show those students enrolled in each scheduled class instance.
How should I go about doing that?