1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

Entity relationship diagramming problem II. Please help.

Discussion in 'Database' started by Assi9, Aug 5, 2009.

  1. Assi9

    Assi9 New Member

    Sorry to bother you again. I have come across another problem in this assignment of mine.

    It is like this: There is the Student entity (Student_ID, First_name, etc), Module entity (Module_ID, Module_Name, etc.). Now I need to find some way to store the assessment results of the students in their respective modules.

    You will notice that Student and Module have a many-to-many relationship, so I have introduced a weak entity to simplify this. It is called Student Module Registration. Now I'm tempted to create a new entity called Assessment and create a relationship betwen Assessment and Student and Module.

    Problem is, Assessment does not seem to have any primary key and it seems to be just another weak entity, just like Student Module Registration. Is it possible for Student and Module to be related to another weak entity? What would be a better solution than this?
  2. nimesh

    nimesh New Member

    You could have a combination of columns as the primary key, in the Module Entity.
    Like combination of StudentId and ModuleID, which would be unique.

    What's the relation between Student, Module and Assessment?
    Like 1 Student will have a particular Module only once, with only one assessment.
    If so, then you can merge Module and assessment together.

    :eek:fftopic: If this problem was related to the same old you, you could have continued in the same thread, instead of creating a new one
    shabbir likes this.
  3. Assi9

    Assi9 New Member

    Thanks again for replying, nimesh. You rule! And I'm really sorry to have created this new thread for the same problem. Won't happen again.

    About the Student-Assessment relationship, a student has to choose 2 modules if part-time, and 4 modules if full-time. Can a combination of both Student_ID and Module_ID be used as candidate keys in the Assessment table in this case?
  4. nimesh

    nimesh New Member

    But can a student enroll for a particular module say XML twice?

    Will the assessment be carried out multiple times or once?
    If multiple attempts, you can add one more key (along with Student_ID and Module_ID) to make the unique record criteria.

    haha, I don't rule. Shabbir rules :)
  5. Assi9

    Assi9 New Member

    No. A student may take four different modules, but according to the scenario, takes a module just once as modules are restricted to just the one programme they belong to and students enroll for just one programme. I think I'm getting your point. I should really try asking myself those questions. Kind of probing the database for answers. Thanks a lot for your help. You have single-handedly changed the way I usually tackle these questions. We are taught a much more orthodox way of analyzing a uod.

    Oh, I'm sure he does. But that doesn't exclude the fact that you too rule! Thanks again for your help. Have a great day/night.
  6. nimesh

    nimesh New Member


    yes, you yourself should frame such questions, get the answers, reanalyze the situation.
    Whether these answer prompt you for more questions? :)

    Others have not replied that does not mean I rule :)

    This is what is my funda:
    You should be clear at the basics. at the fundamentals.
    then whatever language you create your programs in, or whatever database you choose. it doesn't matter.
    if you your fundas and you know how to apply them, that's more than enough.
    From net almost everything is available. softwares, tutorials, samples, forums to help you :)
  7. Assi9

    Assi9 New Member

    Your tips definitely work. I am now normalizing my tables and most of them seem to be in the 2nd normal form already, and some even in the 3rd. You're right I should really be doing more research, and I would have, but they gave use just over a week to design this and there's a vb application to design and code as well. But I think I have them covered, and I have you to thank for the database assignment. Really you were great help. Thanks again. Have a nice day/night.

Share This Page