CIS 523               Fall 2000             Assignment 1 - ER

 

Due: Start of Class on 9/19/00

 

Task:

                Identify entities and their properties, and the relationships  involved in the following situation:

 

The Associated Press (AP) is developing a database to aid its coverage of the 2000 Olympics. They want to keep track of information for countries, including name, continent it is on, population, as well as medal counts (number of golds, silvers, and bronzes); about events, including name (e.g. 400 meter hurdles), broad sport (e.g. track and field), location(s) of event, date and time of finals, gold, silver and bronze winner; about athletes, including name, country, gender, age, a notation of any dramatic background, list of previous Olympics participated in and medals won, list of events they are participating in and their finish in the event.