Question 4

Question 4

The following narrative describes a simplified version of the Organization of Olympic facilities planned from the 1996 Olympics in Atlanta. Draw an EER Diagram that shows the entity types, attributes, relationships and specializations for this application. State any assumptions you make.

The olympic facilities are divided into sports Complexes. Sports Complex are divided into one-sport and multisport type.Multisport complexes have areas of the complex designated to each sport with a location indicator (e.g, center,NE-Corner,etc). A complex has a location, a client organizing individual, total occupied area and so on.

Each complex holds a series of events (e.g the tract stadium may hold any different races). For each event these is a planned date, duration, number of participants, numbers of officials, and so on. A roster of all officials will be maintained together with the list of event each official will be involved in.