Question: why many to many relationship?
Answer: Many-to-Many Relationships Its purpose is to store a record for each of the combinations of these other two tables. It might seem like a bit of work to create, but it's simple to do and provides a much better data structure. To create one for this example, we can create a new table called class_enrolment .