>Coming to this thread late, but I have done a lot of school registration stuff so I offer this general design observation: there should be an entity which is a registration i.e. the registration of a particular student for a particular class. In data this is represented as a join table which hold as FKs the pk of the student and the pk of the course ( I finally learned to avoid the reserved word "class" in school software < g > ) One student will have many courses and one course will have many students. Views that use this pivot table will be able to get either situation. The pivot table is also a very good place to store the grade.

Thank Charles. Makes sense.

What would you do in the case of an elementary school where all classes (oops, courses) are taught by the main teacher to all students in a group?

Alex