I am working on a conceptual model for a database. I have the following entities:
Student (id, name, date of birth, department)
Subject (id, name)
This is a many-to-many relationship, one student may be enrolled in many courses, each course has many students. From what I understand, as I should break this many-to-many relationship by introducing a new into a entity, say 'registered' which allows a one-to-one relationship or one-to-many relationship?
Is this correct design decision?