Semi Formal Outfits Boots

AS 2007/08

STATEMENTS AND POSSIBLE TERMS OF SIGNIFICANCE REVEALED BY READING THE TEXT

the occasion of the International Informatics Olympiad 2008, the organizers want to make a computer system for the management of tenders and the "athletes".
The database must be capable of storing information

• of athletes, who may participate to races both individually and grouped in teams
• of races in various stages
• of locations of race

The Olympics provide a stage school (in each school participant), a regional, a national final and the international tender that will designate the winner and the winning team.

Applicants without the necessary additional assumptions, achieve:

1. analysis reference of reality by identifying possible solutions and choose the one that in its reasoned opinion is the most suitable to meet the specifications
2. a conceptual schema of the database
3. a logical database
4. the definition of the relations of the database language SQL
5. the following queries expressed in SQL:

• print a list of athletes grouped by teams for each phase
• named print of an athlete's results in several races in which he participated
• print the schedule of races
• print an information (name, school of origin, nationality) of the winner and the winning team
• print the standings for each race (with the same score Priority is given to younger athletes)
• update, for each stage (school-regional-national-international) any high scores
• calculate the average score obtained during the initial screening for each school
• print for each team the number of "athletes" el participants' average age

6. user interface that the candidate intends to propose to interact with the database and code in a programming language to choose a significant segment of the project realized.
7. a website that presents the public with the classification of different races.