Hello,
Here is some brief background to my question, I am designing a system so that students can choose up to 6 modules with some constraints.
My design has 3 tables, Module Table, Student Table and an Options Table.
The Options Table has 2 fields which are ModuleID and StudentID (The...