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

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

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

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

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 4 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.