I have a situation where I need to design subjects database for a class(grade) of a school which may contain one or more sets of optional subjects.
As an example, I have included 3 main tables which are student,core_subjects and elective subjects. Each student is enrolled in the core_subjects and if the core_subject is an elective subject, the student has to make a selection from a set of elective subject related to the core_subject.
Please have a look at the attached image and if anyone could suggest me whether its a good design and give me some idea if there are other design ideas to manage optional subjects.
Last edited by bishnu; 04-09-12 at 22:10.
Reason: change title to give more meaning