Olympics Example

1
Olympics Example

• The following describes a simplified version of
  the organization of Olympic facilities planned
  for the summer Olympics.
• Draw an EER diagram that shows the entity types,
  attributes, relationships and specializations for
  this application. State any assumptions you
  make.
• The Olympic events will be held in various Sport
  Centers. Sports centers are divided into
  one-sport and multi-sport types. Each complex has
  an address, and the number of sports that will be
  held there. One-sport centers have a maximum
  seating capacity, and multi-sport centers have a
  listing of areas for different sports.
• A complex has a location, chief organizing
  person, total occupied area etc. Each complex
  holds a series of events. For each event, there
  is a planned date, duration, number of
  participants, number of officials.
• A list of all officials will be maintained
  together with the list of events each official
  will be involved in. The officials name,
  registration number and Start Date will be kept.
  
• Different equipment is needed, some for the
  events, some for maintenance. It is important to
  keep track of which equipment is used for each
  event, and at which complex the maintenance
  equipment is used.