Results 1 to 1 of 1
  1. #1
    Join Date
    May 2007
    Posts
    9

    Database design for Optional Subjects enrollment

    Hi all,
    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.

    Cheers,
    Attached Thumbnails Attached Thumbnails subjects.bmp  
    Last edited by bishnu; 04-09-12 at 22:10. Reason: change title to give more meaning

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •