Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2002
    Philadelphia, PA

    Need help with an ERD

    Not too good with the whole ERD thing. Perhaps somebody can come up with a diagram for me or explain it. Here is the problem...

    There is a rowing regatta that is held once a year. At this regatta many schools compete in many events. One particular school cannot compete in the same event more than once (1 boat/event). Each boat that races in an event has 1 or more rowers. No rower can race in more than one event. Each school has one head coach. Each head coach can only coach one school.

    If someone can make more sense of this than me I would be appreciative. Please email to Thanks -Ian

  2. #2
    Join Date
    Apr 2002
    Toronto, Canada
    ian, i hope this isn't homework, i hate doing people's homework for them

    SCHOOL (schoolid, schoolname)

    EVENT(eventid, eventname)

    RACE (schoolid, eventid, datescheduled)

    this is the classic many-to-many relationship structure

    by making schoolid and eventid a composite primary key, each combination can occur only once, so a particular school cannot compete in the same event more than once

    ROWER(rowerid, schoolid, rowername)

    this is a one-to-many from school to rower

    you didn't say so, but this limits the rower to only one school

    RACEROWER (schoolid, eventid, rowerid, datescheduled)

    with only this structure it would be possible for a rower to participate in more than one event, so you also need a unique constraint on (eventid,rowerid)

    COACH (coachid, schoolid, coachname)

    one-to-many from school to coach


Posting Permissions

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