The following narrative 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 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, NE corner, 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 (e.g., goal posts, poles, parallel bars) as well as for maintenance. The two types of facilities (one-sport and multisport) will have different types of information. For each type, the number of facilities needed is kept, together with an approximate budget.

Step by step solution

01

Define Entities

Firstly, identify and define the entities in the problem statement. From the given problem, the entities are 'Olympic facilities', 'Sports complexes', 'Events', 'Officials', 'Equipment', and 'Budget'.

02

Identify Entity Attributes

Next, pinpoint the attributes for each entity. For instance, a 'Sports complex' has attributes like 'location', 'chief organizing individual', and 'total occupied area'. An 'Event' has attributes like 'date', 'duration', 'number of participants', and 'number of officials'.

03

Define Relationships

Define the relationships between the entities. For example, a 'Sports complex' holds 'Events', thus setting up a relation. Similarly, an 'Event' needs 'Equipment' and is managed by 'Officials'.

04

Specialization of Entities

It's necessary to identify entities that have specializations. Here, 'Sports complexes' are divided into 'one-sport' and 'multisport' complexes.

05

Draw EER Diagram

Finally, using all the identified details, draw the EER diagram. Show the entities, their attributes, the relationships between them and the specialization subgroups. Each Olympic facility is depicted as an entity connected to its sports complexes. Each sports complex entity is related to its events, and the events in turn are connected to involved officials.

Unlock Step-by-Step Solutions & Ace Your Exams!

• Full Textbook Solutions

  Get detailed explanations and key concepts

• Unlimited Al creation

  Al flashcards, explanations, exams and more...

• Ads-free access

  To over 500 millions flashcards

• Money-back guarantee

  We refund you if you fail your exam.

Start your free trial

Over 30 million students worldwide already upgrade their learning with Vaia!