KöMaL - Középiskolai Matematikai és Fizikai Lapok
Sign In
Sign Up
 Magyar
Information
Contest
Journal
Articles

 

Problem I. 305. (November 2012)

I. 305. The Hungarian Central Statistical Office (abbreviated as KSH in Hungarian and in this exercise) publishes some basic data on settlements in Hungary each year. This exercise is based on the report made available on January 1, 2011. We remark that it contains data for the capital city as well, however, not as a whole city, rather than data for each of its districts.

[1.] You should create an empty database i305. You should import data into the tables helyseg, kisterseg, megye, megyeresz, onkormanyzat, telepulestipus, kisebbseg from the text files with similar names. (The text files are UTF-8 encoded and tabulator separated with first lines containing the field names.) The relations among the tables are shown in the figure.

Tables:

[2.] Create a query listing settlements of the Kecskemét region and sorting them according to decreasing population. (2kecskemet)

[3.] Create a query giving the number of regions in each county. (The capital city should be ignored.) The list should be sorted according to county names in alphabetical order. (3kistersegek)

[4.] List by using a query the number of settlements of each type in Hungary. (4tipusok)

[5.] Create a query giving the number of square kilometers of the area of Budapest (1
\text{ hectare} = 0.01~\rm km^{2}). (5bpter)

[6.] By using a query, list settlements having an Armenian minority government.\ (6ormeny)

[7.] By using a query, give the number of settlements having at least 5 local minority governments. (7sokkisebbseg)

[8.] By using a query, give the names of the 30 most densely populated settlements, together with their population size and population density measured in people/hectare. (8suru)

[9.] How many settlements are there in each county whose names begin or coincide with one of the words of the name of its county? (9johelyen)

[10.] List those settlements whose names begin with one of the words of the name of another county. List the settlement name and its county name as well. (10máshol)

The database (i305.mdb, i305.accdb, i305.odb, ...) together with a short documentation (i305.txt, i305.pdf, ...) - also containing the name and version number of the database application - should be submitted.

Downloadable file: i305forras.zip

(10 pont)

Deadline expired on 10 December 2012.


Sorry, the solution is available only in Hungarian. Google translation

Először is elnézést, hogy csak most sikerült a beküldött dolgozatok javítását befejeznem. Szinte minden megoldót becsapott az ACCESS sajátságos "magyar nyelv kezelése". Sajnos például a Like”an*” nem fogja megjeleníteni az anya szót, mert abban nem „n”, hanem „ny” betű van, így ezt csak egy kis munkával tudták volna a [9.] és [10.] feladatrészekben korrigálni, valahogy így: Left([Helyseg]![Nev];Len([Megyeresz]![Megyenevresz]))=[Megyeresz]![Megyenevresz]

Mellékelem Fényes Balázs (Budapest, Szerb A. Gimn.) és Qian Lívia (Szeged, SZTE Ságvári E. Gyak. Gimn.) e problémától nem mentes, de egyebekben hibátlan munkáját.

Mindenkinek további sok sikert kíván a versenyzéshez a szerkesztő.

mintamegoldasok.zip


Statistics:

13 students sent a solution.
10 points:Fényes Balázs, Qian Lívia.
9 points:Gema Barnabás, Jákli Aida Karolina, Tilk Bence.
8 points:2 students.
7 points:3 students.
5 points:1 student.
4 points:1 student.
1 point:1 student.

Our web pages are supported by:   Ericsson   Cognex   Emberi Erőforrás Támogatáskezelő   Emberi Erőforrások Minisztériuma   Nemzeti Tehetség Program    
MTA Energiatudományi Kutatóközpont   MTA Wigner Fizikai Kutatóközpont     Nemzeti
Kulturális Alap   ELTE   Morgan Stanley