Problem I. 191. (September 2008)
I. 191. John likes movies so he made a list of films he saw between February 1, 2001 and February 29, 2008. These are contained in the downloadable file mozadat.txt.
1. Prepare a database with name i191. Import the given table (containing titles of films, date of viewing, and ticket prices) with name moz_adat into your database. The text file is tabulator separated and field names are contained in the first line.
2. After importing, the appropriate data formats and a key should be set. A new identifier should also be created.
Now solve the following tasks and save the results with names given in parentheses.
3. Using a query, print all data of the films viewed on his birthday April 14 (3birthday).
4. Using a query, give those dates when more than one film has been viewed. The number of films should also be given (4morefilms).
5. Using a query, list the number of films watched in each month together with their prices. The list should contain the years, months, number of films and sum of ticket prices for every month (5monthlylist).
6. Using a query, determine those months between February 1, 2001 and February 29, 2008 in which John did not see any movie (6break).
7. Make a query that prints the film titles in alphabetical order if some part of the title is given as a parameter (7list).
8. List the film names that John saw more than once but at different prices (8different).
9. Using a query, determine what percentage of the films he watched during summer months (6th, 7th and 8th months) (9summer).
The database (i191.odb, i191.mdb, ...) or a text file (i191.txt, i191.pdf, ...) should be submitted containing the creation of the table and the queries in SQL-format arranged neatly, together with a short documentation (i191doc.txt, i191doc.pdf, ...) with the name and version number of the database manager.
Deadline expired on October 15, 2008.
Sorry, the solution is available only in Hungarian. Google translation
A D_tabla a megadott időszak minden évét és hónapját tartalmazza a mikor mezőben.
(Barta111 János, Pap987 Dávid és Szabó928 Attila munkája alapján)
25 students sent a solution. 10 points: Kővágó Zoltán, Pap 999 Dávid, Szabó 313 Gábor, Szabó 928 Attila. 9 points: Barta 111 János, Molnár Gábor, Póta Kristóf. 8 points: 4 students. 7 points: 2 students. 6 points: 4 students. 5 points: 2 students. 4 points: 2 students. 2 points: 2 students. 1 point: 2 students.