I'm making a system for a college and one of the subsystems I'm building is the student newsletter. I put it to when creating a new discipline in the table "discipline" this discipline is added to the "notes" table with a record for each id of each student enrolled in the course which the discipline belongs and with the field note in these new registers. p>
The notas
table would look something like this:
id int(11)
iddisciplina int(11)
idcurso int(11)
idaluno int (11)
nota int(11)
But doing so, with a large amount of students this would generate a lot of data and when I needed to delete a course for example, I would have to go out sweeping all the notes related to that course and disciplines and this would have a great performance cost .
Are there any better and more optimized ways to do this?