Introduction

Statistics Finland (www.stat.fi) operates administratively under the Ministry of Finance, but is fully and independently responsible for its activities, services and statistics. Statistics Finland has a personnel of around 1,100, of whom 200 are employed as statistical interviewers. In addition to its head office in Helsinki, Statistics Finland has regional service offices in Turku, Tampere, Seinäjoki and Oulu. Statistics Finland combines collected data with its own expertise to produce statistics and information services for the needs of society, promotes the use of statistics and develops national official statistics.

Requirements

Statistics Finland needs an information web system that helps find out which languages are spoken in a given country or which cities are situated in a given country.

Statistics Finland provides a world.sql file containing the create table and the insert statements and an ERD diagram document containing the ERD diagram of the database. The data used in the world database is copyright Statistics Finland, http://www.stat.fi/worldinfigures.

The architecture of the system has to be multi-tier; the clients use a web browser, the application is running on a glassfish application server and the database on a MySQL server.

Goal state

Using goal state gives an idea about the functionality and interfaces of how the final product should look like.

Solution

The complete solution is provided by a tutorial. Please, perform this tutorial.