Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2010

    Unanswered: How to map this case??

    How can i map these two entities into relations(tables) with the concept of normalization:

    1)Students:Name, birth date, guardian e-mail.

    2)Subjects: Mandatory (Math, science) and Elective (Biology,History,French)
    Each student must study mandatory subjects and two elective subjects.

    I know that i can do it like :
    Subject Master
    SubjectType (mandatory/elective)

    OtherInfo Eg. class


    But the thing is why would i add all the mandatory subjects in the Datatable as they will be assigned to every student??

    Thanks in advance.

  2. #2
    Join Date
    Jan 2010
    For two reasons.

    First, you're going to be reporting on the database and you're going to want to get all details for students in a standard way - you won't want to do something like "plus Match and Science" to the query.

    Second, the mandatory subjects could/will change. Most education authorities change their minds (or rather, the political masters change their minds). You may as well cater for this in your design so that when it happens, all you got to do is change your front end to the database (and you won't need to change the "plus Match and Science" stuff).

    You're going to need a subject description in your Subject Master table but you've probably done enough to get a good grade.

Posting Permissions

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