Transcript Olympics Example - Bilkent University

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.