Results 1 to 6 of 6
  1. #1
    Join Date
    Apr 2009
    Posts
    4

    Unanswered: Entity Relationship

    heyy hii guys

    i have make E-R for the system that allows lecturer to analyse student attendance for each modul.

    i have created tables as below:-

    student
    studentid
    surname
    inits
    sex
    phone
    email
    logon

    studattendance
    studattendanceid
    modpartoccurid
    studentid
    att_time
    att_date
    semester

    Modpartoccur
    modpartid
    acyear
    semester
    occletter
    modpartid
    room
    lecturerid
    DOW
    timestart
    duration

    Modul
    modulid
    modulname
    modulevel

    I am unable to get how should i connect studattendance to modpartoccur.
    Any help appreciated!!

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    i have make E-R for the system ...
    how should i connect studattendance to modpartoccur?
    Well, if you have created the model, you should know how to do that. It is supposed that you KNOW what you want to have as a result. If not, huh, that's the problem.

    If, on the other hand, you have copied someone else's solution, perhaps you should ask him/her what is wrong with the model.

    So: think about it! It's not that difficult.

  3. #3
    Join Date
    Apr 2009
    Posts
    4
    Well thnx for your reply and this is just assignment.

    if, on the other hand, i would have copied it as u say i would have asked him.

    I have trouble with attendance table and modpartoccur which i am trying my best to solve it out.

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    I am unable to get how should i connect studattendance to modpartoccur.
    Obviously, this should be done by the means of a common column. If it can not exist in these tables, then you'll have to create a "bridge" via other table(s) in a model.

    So, can you do that directly? Is it possible to join "attendance" with "modpartoccur" using a single column that exists in both tables? If so, no problem. If not, which tables do you have to join in order to create that relationship?

  5. #5
    Join Date
    May 2009
    Posts
    1
    All work submitted must be your own, after your requests for help here & on other forums I am not completely satisfied that your assignment will be.

    Please do not submit your assignment through the usual channels as it will not get marked. Your assignment must be handed in to me personally no later than 16:30 tomorrow, where you will have to explain your erd, data dictionary and proposals for a card scanning system as decribed in part two of the assignment.

    ..Jim

    Quote Originally Posted by gsb1bee
    Well thnx for your reply and this is just assignment.

    if, on the other hand, i would have copied it as u say i would have asked him.

    I have trouble with attendance table and modpartoccur which i am trying my best to solve it out.

  6. #6
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Ooops! Does the previous message mean that the Big Brother is watching

Posting Permissions

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