Students take many courses and courses have many students. How is this usually modeled?
- One table holding both entities
- A course list column in students
- A junction table of both keys
- A foreign key on each side only
A many-to-many relationship needs a link table such as
Play SQL & Databases ▸
enrollments(student_id, course_id).