THE leader in sports information

Phase IV

April 13, 1998

Rob Hagan

Team 2.4

John Zenger, Project Manager

Tim Hodges

Brenda Ley

George McMonigole

Memorandum

Date: 4/13/98
To: Tampa Committee for the Olympic Games
From: Rob Hagan
RE: Logic and Data Models

The attachments to this memo contain entity-relationship diagrams (ERDs) with definitions and Pseudo code for the data flow diagrams (DFDs) presented in Phase II of our report.

The ERDs show a visual representation of all the entities involved with our system and the attributes of each entity. It also shows the relationships between each of these entities and how they interact with each other. The definitions of the entities and their accompanying attributes are attached to the back of the diagrams for reference if you have any questions.

The Pseudo code of is a computer-based set of instructions for carrying out the processes presented within the DFDs. The language used in this code is simple enough to understand on a personal level yet is structured like a programming language to be entered into the computer. The main purpose of the Pseudo code is to present how the system will work on a level that is easily understandable.

Please review the diagrams and code and inform us of any changes or improvements we may have overlooked. This is the last phase of the preliminary stages to implementing the system so if this report is satisfactory, we can begin impleme ntation of our system immediately.

Attachments

Level-0 Diagram
Begin
While customer wants information
Input user query
If query deals with history
Access history database
History = history information
Else if query deals with events
Access events database
Event = event information
Else if query deals with athletes
Access athlete database
Athlete = athlete information
Else if query deals with medals
Access medal database
Medal = medal information
Print "History, Event, Athlete, Medal"
Print "Would you like to find anything else"
If "no"
break
Do
End
Level-1 Diagram
Begin
Input query into medal process
While information is needed
Get information from database
For (I = 1 to number of items in query)
Get information
Info[I +1] = information
Next I
Medal = info
End
Level-2 Diagram
Begin
While medal data < data queried
Access medal database
Retrieve specific information
Info = medal information
Do
End

Condensed Worldwide Sports ERD:

Comprehensive ERD

Data Depository
ENTITIES:
USER - The interface for the user at the kiosk. This entity will contain an Interface ID and an individual query ID for each query made.

HISTRCAL - The historical database will contain the date, event, and results of all previous Olympics.

EVENT - The event database containing event results, event ID, event name, date, miscellaneous other information (such as weather) related to a particular Olympic event.

ATHLETE - The athlete database containing the background, medals won, athlete ID, and name of each participant.

MEDAL - The medal database will contain the medal status, medal IDs, Athlete name, event, and date the medal was won.

PRIMARY ATTRIBUTES:

USER QUERY_ID - This ID number will be a unique number that is assigned to each query made up of a combination of the interface ID and the query counter at each location.

HISTRCAL HIST_ID - This ID number is a combination of the date, event, and result which will yield an individual number for each result from this database.

EVENT EVENT_ID - The Olympic ID code assigned to each recognized event in the Olympics.

ATHLETE ATHLT_ID - The number assigned to each recognized competing athlete in the Olympics.

MEDAL MDL_ID - The ID of each medal issued during the Olympics. This medal ID will contain all information related to the medal such as athlete awarded to, medal stat (gold, silver, bronz), event, and date.

ATTRIBUTES:

USER INTERFCE_ID - The identification number of the touchscreen/computer that user is using.

HISTRCAL DATE - Date that the archived event occurred.

HISTRCAL EVENT - Name of the event stored in the archive.

HISTRCAL RESULTS - Results of the particular event in history.

EVENT DATE - Date the event occurred.

EVENT MISC - Relevant information surrounding the event such as weather and records broke.

EVENT RESULT - Results of the event i.e. ranking.

EVENT NAME - Name of the event.

ATHLETE NAME - Name of the Athlete.

ATHLETE BCKGRD - Background of the Athlete i.e. personal information, accomplishments, etc.

ATHLETE MEDALS - The previous medals won by the athlete.

MEDAL DATE - Date the medal was won.

MEDAL MDL_STAT - Medal status i.e. gold, silver, bronze.

MEDAL MDL_ID - Medal identification number which is assigned by the Olympic information committee and identifies the medal with the event or athlete.

MEDAL ATHLETE - The name of the Athlete that won the Olympic medal.

[Home] [Project Plan] [Requirements Document] [Phase I] [Phase II] [Phase III]

This web site was created for a systems analysis class (ism 3113). It is intended for educational purposes only.