can some1 help me with ER diagrams plssssssssssss!!!

Discussion in 'Software' started by mateo, May 17, 2010.

  1. mateo

    mateo Private E-2

    You are required to develop an Entity Relationship diagram from the following information that depicts the involvement of staff members and their association with research projects at a particular university.
    The diagram needs to display entities, their attributes where stated and their relationships with other entities. For each relationship both the maximum and minimum cardinality must be displayed.
    A university has many staff members and a staff member may be involved in many research projects.
    A research project must have at least one staff member assigned to it.
    The time (days) a staff member works on a specific project must be recorded.
    An individual research project is managed by one and one only staff member, but a staff member may manage more than one research project.
    A staff member works for one school only and a school has at least one staff member in it.
    Each research project is assigned to a category. A category may be associated with many research projects but an individual research project must be assigned to one category only.
    The findings of a research paper may be presented at many at many conferences and a conference must present the findings of at least one research project. The date at which a research project is presented at conference must be recorded.
    ------------------------------------------------------------------------
    You are required to create an Entity Relationship diagram from the following scenario. The scenario you are to model relates to athletes competing at athletic events.
    The entity relationship diagram must display entities, their attributes and their relationship with other entities. For each relationship both the maximum and minimum cardinality must be displayed.
    When an athlete competes at an athletics carnival their results are required to be maintained for future reference.
    An athlete is described by a unique competitor number, first name, surname, date of birth and gender. During an athlete’s career they may belong to many clubs and a club may have many athletes associated with it. But, during a particular season (year) an athlete may only represent one particular club, but has the right to change clubs in any subsequent year (season). The ER model must be able to identify the club an athlete represents in any particular year.
    A club is represented by a unique club number, name, address, and phone number. For each season one athlete within each club is chosen to be its captain. In any one season an athlete may captain one particular club and a club must only have one assigned captain per season.
    An athletics carnival is held on a particular date and at a specific location. A carnival is also identified by a specific carnival number and the condition of the day is also recorded. For example the condition could be either, wet, cold, hot, good, windy or dry. Each carnival is assigned to one condition type but a condition type could be used to describe the state of many different carnivals. A condition is described by a unique number, and a description.
    Each carnival is held at a specific location and a location could be used for many carnivals. Location is described by a location number, description and state.
    At any carnival there are a number of events that take place. An event is represented by a unique number, description, gender and age group. For example Boys Under 14 100M and Girls Under 16 High Jump. An event may be run at many different carnivals and a carnival must run at least one event.
    When an athlete competes in a particular event at a specific carnival their performance or result must be recorded. Their placing and the distance or time they received must be recorded.
    The current record holder for each event must be recorded. An athlete may hold the record for many events and an event has only one record holder at any one time


    ANY HELP IS REALLLYYY APPRECIATEDDDDD!!!!!!!!!!!!!!!!!!!!!!!!!!!!
     
  2. PC-XT

    PC-XT Master Sergeant

    This sounds like a class assignment, in which case your instructor will probably be most qualified to handle your questions. Sometimes I have had others tell me things that were slightly different from the teaching or textbook, and got questions wrong because I followed them. My teacher sometimes said both ways are acceptable in practice, but I was supposed to learn the textbook's way. :|
     

MajorGeeks.Com Menu

Downloads All In One Tweaks \ Android \ Anti-Malware \ Anti-Virus \ Appearance \ Backup \ Browsers \ CD\DVD\Blu-Ray \ Covert Ops \ Drive Utilities \ Drivers \ Graphics \ Internet Tools \ Multimedia \ Networking \ Office Tools \ PC Games \ System Tools \ Mac/Apple/Ipad Downloads

Other News: Top Downloads \ News (Tech) \ Off Base (Other Websites News) \ Way Off Base (Offbeat Stories and Pics)

Social: Facebook \ YouTube \ Twitter \ Tumblr \ Pintrest \ RSS Feeds