this is for database mangemeemt systems class

The Olympic facilities are divided into sports complexes. Sports complexes are divided into one sport and multisport types. Multisport complexes have areas of the complex designated for each sport with a location indicator (e.g., center, North East corner, South, etc.). A complex has a location, chief organizing individual, total occupied area, and so on. Each complex holds a series of events (e.g., the track stadium may hold many different races). For each event there is a planned date, duration, number of participants, number of officials, and so on. A roster of all officials will be maintained together with the list of events each official will be involved in.

Different equipment is needed for the events themselves (e.g., goal posts, poles, parallel bars) as well as, another set of equipment is needed for the maintenance of each sports complex (e.g. cleaning equipment, grass cutters, etc.). The two types of facilities (one-sport and multisport) will have other types of information. For each type of facility, there are number of amenities available (e.g. internet caf, gym, pool, etc.) together with an approximate budget for each amenity.

Requirements

You are required to develop a data model using an Extended Entity-Relationship Diagram (EERD). The model should represent the information above, so that it can be used to automatically determine the applicability of each discount

Your model should provide entities, relationships, identifiers and minimum and maximum cardinality for each relationship. For each entity, you must indicate the identifier and other required attributes.

If used, composite attributes should be shown properly broken down into their simple components

Multivalued attributes should be converted into their own entities.

Add associative entities when needed, identifying their relevant attributes. You need two attributes at a minimum per associative entity

If subtype entities are used, use a minimum of one specialized attribute per each subtype

You may list the assumptions in the model, if necessary. Assumptions have to be made only if they are not clear in the above description. You can include the assumptions on the model using SmartDraw text tool. A list of unnecessary assumptions will be ignored.

Please put your name on the model using SmartDraw text tool