Results 1 to 2 of 2

Thread: ERD help

  1. #1
    Join Date
    Jul 2011

    Unanswered: ERD help

    Trainset run professional short courses. These courses have a title, a duration of 1,2,3,4,or 5 days, and a cost that varies between 300 and 2000. The courses are repeatedly run at various locations. The start date of each offering, its location and its instructor are recorded. Students attend the courses and Trainset need to record the student name, gender, telephone number, and company name. Each time a student attends a course they will give an evaluation of the course (the evaluation is a number from 0 to 4), and attempt an examination. Trainset need to record the examination result of each student in each examination. It is not a requirement that all offerings of courses have attendees registered, and it is also not required that every student has to have attended a course.

    please help me, how to draw erd for above scenario
    5 entities (Student, instructor,course, offering, taking/attendance)
    how to show optionality
    Attached Thumbnails Attached Thumbnails IMG_1034.JPG  

  2. #2
    Join Date
    Jun 2003
    West Palm Beach, FL


    Perhaps you could get a better idea from this model or similar.

    Good Luck!
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

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