Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2012
    Posts
    3

    Help with ER modelling

    I'm new to ER modelling and i'm having trouble finding the entities.

    Question:

    Produce an Entity-Relationship Model using UML notation.
    Convert to a relational model by specifying the primary and foreign keys, mapping any one-to-one relationships into relations, and decomposing any many-to-many relationships.


    MyArea Film and Literary Society (MLFS) provide groups and events for local people. All participants must be members (who pay an annual fee) or their guests who may attend events. Fees vary from one group to another. In addition members may have a reduction in fees depending on their type of membership. For example Individual members pay 100% fees and Concessionary members pay 50%. There are also Household members and a special category called Friends of the Society.

    The Society hosts a number of groups which meet monthly. Members can join one or more groups; currently these include Film, Science, Reading and Poetry Groups.

    Note that the group code and the ability code are both based on the same domain of values. The latter represents members’ talents which the Society may make use of – this is described later. One group of a particular type (such as Poetry) will be run each year, assuming there are nine or more members who want to join a group. Each group is run by a coordinator, who may change from one year to the next. In addition to the above, the society holds the address and telephone number of each coordinator.

    Besides groups, the society also holds one-off special events, such as lectures, films, art exhibitions and musical evenings. Events do not relate to particular groups: they are open to all members and their guests and are organised by one of the coordinators. Events will be led by an outside speaker, or sometimes a member (who have special talents as shown in the example record above) will act as the speaker.

    Each event will have only one speaker (whether an outside speaker or a member speaker), but a speaker may speak at a number of events. Details will be held of the event name, the date, and venue and outside speakers (name and telephone number). The Society will keep records of members who attended events and the number of guests for each member per event.



    Thank you all

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    sorry, we don't do homework for people on this site
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Oct 2012
    Posts
    3
    thanks for the response anyway

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    make an effort
    try to develop your own model
    if you get stuck on a thorny problem by all means ask. you may get an answer to homework if you make an effort. you wont get an answer if you make no effort
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Oct 2012
    Posts
    3
    Quote Originally Posted by healdem View Post
    make an effort
    try to develop your own model
    if you get stuck on a thorny problem by all means ask. you may get an answer to homework if you make an effort. you wont get an answer if you make no effort
    I think the way I have asked the question makes it seem as though I want my problem to be resolved by someone else. However I have started to pick out the entities and it is the entities that I am stuck on, the rest I can manage. So far I have identified the entities as being:

    Members
    Groups
    events
    guests
    talents
    coordinator

    I know that there are more than the ones that I have picked I just cant seem to figure it out.

    Thanks

Posting Permissions

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