Studying at the University of Verona
Here you can find information on the organisational aspects of the Programme, lecture timetables, learning activities and useful contact details for your time at the University, from enrolment to graduation.
Academic calendar
The academic calendar shows the deadlines and scheduled events that are relevant to students, teaching and technical-administrative staff of the University. Public holidays and University closures are also indicated. The academic year normally begins on 1 October each year and ends on 30 September of the following year.
Course calendar
The Academic Calendar sets out the degree programme lecture and exam timetables, as well as the relevant university closure dates..
Period | From | To |
---|---|---|
I semestre | Oct 4, 2010 | Jan 31, 2011 |
II semestre | Mar 1, 2011 | Jun 15, 2011 |
Session | From | To |
---|---|---|
Sessione straordinaria | Feb 1, 2011 | Feb 28, 2011 |
Sessione estiva | Jun 16, 2011 | Jul 29, 2011 |
Sessione autunnale | Sep 1, 2011 | Sep 30, 2011 |
Session | From | To |
---|---|---|
Sessione autunnale | Oct 20, 2010 | Oct 20, 2010 |
Sessione straordinaria | Dec 14, 2010 | Dec 14, 2010 |
Sessione invernale | Mar 23, 2011 | Mar 23, 2011 |
Sessione estiva | Jul 18, 2011 | Jul 18, 2011 |
Period | From | To |
---|---|---|
All Saints | Nov 1, 2010 | Nov 1, 2010 |
National holiday | Dec 8, 2010 | Dec 8, 2010 |
Christmas holidays | Dec 22, 2010 | Jan 6, 2011 |
Easter holidays | Apr 22, 2011 | Apr 26, 2011 |
National holiday | Apr 25, 2011 | Apr 25, 2011 |
Labour Day | May 1, 2011 | May 1, 2011 |
Local holiday | May 21, 2011 | May 21, 2011 |
National holiday | Jun 2, 2011 | Jun 2, 2011 |
Summer holidays | Aug 8, 2011 | Aug 15, 2011 |
Exam calendar
Exam dates and rounds are managed by the relevant Science and Engineering Teaching and Student Services Unit.
To view all the exam sessions available, please use the Exam dashboard on ESSE3.
If you forgot your login details or have problems logging in, please contact the relevant IT HelpDesk, or check the login details recovery web page.
Academic staff
Bertelle Roberto
Guarnieri Valerio
valerio.guarnieri@univr.it +39 045 802 7085Study Plan
The Study Plan includes all modules, teaching and learning activities that each student will need to undertake during their time at the University.
Please select your Study Plan based on your enrollment year.
1° Year
Modules | Credits | TAF | SSD |
---|
2° Year activated in the A.Y. 2011/2012
Modules | Credits | TAF | SSD |
---|
3° Year activated in the A.Y. 2012/2013
Modules | Credits | TAF | SSD |
---|
Modules | Credits | TAF | SSD |
---|
Modules | Credits | TAF | SSD |
---|
Modules | Credits | TAF | SSD |
---|
Legend | Type of training activity (TTA)
TAF (Type of Educational Activity) All courses and activities are classified into different types of educational activities, indicated by a letter.
Databases (2012/2013)
Teaching code
4S00037
Credits
12
Language
Italian
Scientific Disciplinary Sector (SSD)
INF/01 - INFORMATICS
The teaching is organized as follows:
Teoria
Laboratorio
Learning outcomes
Theory I
-------
The first part of the course, called “Databases Theory”, has the aim to provide the student with the necessary concepts and methods for the design of a database and its applications. In particular, it will be focused on the methodologies for the conceptual and logical design of a database and for the successive database implementation on database systems. Moreover, some general techniques for the implementation of database systems will be presented and the fundamental characteristics of the query language SQL and of the relational algebra will be illustrated.
Theory II
-------
The second part of the course, called “Web and multimedia Applications”, has the aim to provide the student with the necessary concepts and methods for the design of data-intensive web applications. In particular, this module will be focused on a methodology for the logical design of a web application that interacts with a database system (DBMS).
Moreover, the approach Model-View-Controller (MVC-2 servlet centric) will be illustrated and applied to some examples. Finally, the main issues concerning the treatment of multimedia datasets in a DBMS will be presented.
LAB
-------
The “Lab” ("Laboratorio" in italian) of the course “Databases and WEB” has the aim to provide the student with the necessary concepts and methods for the implementation of a database and its applications. In particular, this module will be focused on the usage of a specific DBMS for the creation, management and manipulation of a database by means of SQL commands. Moreover, some general techniques for the implementation of web applications will be presented. In particular a MVC-2 architecture based on the Servlet and the Java Server Pages (JSP) technologies will be illustrated and used to show the implementation of some practical examples.
Program
Theory I
-------
* Introduction to database managemente systems (DBMS): architectures and functionalities of a DBMS. Phisical and logical data independence. Data models. Concepts of model, schema and instance of a database. Languages for database systems. DBMS vs. file system.
* Conceptual database design: conceptual data models. The Entity-Relationship model (ER). Elements of the ER model: entities, attributes, relationships, ISA hierarchies and cardinality constraints.
* Logical database design: logical data models, the relational data model. Elements of the relational data models: relations and integrity constraints. Mapping between conceptual schemas in ER model and logical schema in the relational model. Languages for data definition: SQL as DDL. Table creation and integrity constraints definition in SQL.
* Interacting with a database system: languages for the definition, querying and update of a database. The relational algebra. SQL: select-from-where statement, join in SQL, the GROUP BY and ORDER BY clauses, using subqueries. SQL for update: INSERT, DELETE and UPDATE statements. Views.
* The internal architecture of a DBMS. Transactions. Transactions properties. The concurrency control: schedules, view and conflict equivalence, the two-phase locking. Access methods (indexes): primary and secondary indexes, B-+tree, hashing based access methods.
Theory II
-------
The module is organized in 16 hours of lessons and exercises carried out during the second semester. The module will focuses on the logical design of a data-intensive web application and its implementation using: Postgresql, Servlet and Java Server Pages (JSP) technologies. Moreover, the issues concerning the treatment of multimedia datasets in a DBMS will be presented.
In particolar, the following arguments will be illustrated:
* Web Server: basic internet, basic HTML (form), basic HTTP.
* Information systems on the Web: techniques for the interaction between a DBMS and a HTTP server (CGI, Servlet, JSP); JDBC library and Java data beans; the architecture proposed by the MVC-2 approach.
* a methodology for the logical design of a data-intesive web application.
* XML
* features of multimedia data: compression techniques and indexing
LAB
-------
1. Introduction to DBMS PostgreSQL: connection to a database, table creation, insert, update and alter table.
2. PostgreSQL: integrity constraints, reactions to contraints violations.
3. PostgreSQL: simple SQL queries.
4. PostgreSQL: complex SQL queries.
5. HTML: structure of an HTML document, main tags, tables.
6. HTML: form.
7. Servlet Engine on an application server. Examples of simple servlets.
8. Servlet and JDBC. Connection to a DBMS PostgreSQL. Simple servlet of the interaction with a DBMS.
9. Java bean e servlet.
10. Java Server Pages (JSP), PHP and other languages for web applications.
11. JSP and servlet: a software architecture based on the Model View Controller approach.
12. Servlet/JSP and multimedia datasets.
Bibliography
Activity | Author | Title | Publishing house | Year | ISBN | Notes |
---|---|---|---|---|---|---|
Teoria | P. Atzeni, S. Ceri, P. Fraternali, S. Paraboschi, R. Torlone | Basi di dati. Architetture e linee di evoluzione | McGraw-Hill | 2003 | 88-386-603 | |
Teoria | P. ATZENI, S. CERI, S. PARABOSCHI, R. TORLONE | Basi di dati- Modelli e linguaggi di interrogazione (Edizione 3) | McGraw-Hill | 2009 | 9788838666001 | |
Teoria | E. Baralis, A. Belussi, G. Psaila | Basi di dati - Temi d'esame svolti (Edizione 1) | Progetto Leonardo Società Editrice Esculapio Bologna | 1999 | B135655713 |
Examination Methods
Written tests.
Teaching materials e documents
- Algebra relazionale: ottimizzazione (it, 293 KB, 10/12/12)
- Applicazioni Web: Data Beans (it, 460 KB, 15/04/13)
- Applicazioni Web: esempio di servlet & JDBC (it, 147 KB, 09/04/13)
- Applicazioni Web: introduzione e protocollo HTTP (it, 357 KB, 26/03/13)
- Applicazioni Web: JDBC (it, 490 KB, 08/04/13)
- Applicazioni Web: JSP (it, 426 KB, 16/04/13)
- Applicazioni Web: metodologia (aggiornato) (it, 316 KB, 15/04/13)
- Applicazioni Web: MVC-2 (it, 450 KB, 29/04/13)
- Applicazioni Web: PHP cenni (it, 364 KB, 30/04/13)
- Applicazioni Web: servlet (it, 261 KB, 08/04/13)
- Concorrenza I (it, 664 KB, 05/03/13)
- Concorrenza II (it, 588 KB, 11/03/13)
- Dati multimediali: codifica di Huffman & LZW (it, 431 KB, 27/05/13)
- Dati multimediali: introduzione (it, 413 KB, 13/05/13)
- Dati multimediali: k-d-tree (it, 358 KB, 27/05/13)
- Esercitazione sulla seconda prova intermedia (it, 334 KB, 29/05/13)
- Introduzione (it, 758 KB, 01/10/12)
- Progettazione logica (it, 1127 KB, 13/11/12)
- SQL-1 (it, 238 KB, 11/12/12)
- SQL-2 (it, 241 KB, 17/12/12)
- SQL-3 (it, 216 KB, 18/12/12)
- Strategie per la progettazione concettuale (it, 142 KB, 22/10/12)
- Strutture di accesso ai dati I (it, 560 KB, 19/03/13)
- Strutture di accesso ai dati II (it, 1801 KB, 19/03/13)
- Transazioni (it, 258 KB, 05/03/13)
- XML (it, 1128 KB, 30/04/13)
- XML: DTD (it, 284 KB, 13/05/13)
- XML: esercizio (it, 141 KB, 08/05/13)
- XMLSchema (it, 983 KB, 06/05/13)
- Esercitazione 10: lucidi (it, 506 KB, 29/05/13)
- Esercitazione 10: php.zip (it, 1 KB, 29/05/13)
- Esercitazione 11: cos.jar (it, 55 KB, 05/06/13)
- Esercitazione 11: esercizio (it, 65 KB, 05/06/13)
- Esercitazione 11: lucidi (it, 208 KB, 05/06/13)
- Esercitazione 11: photos.src (it, 4 KB, 05/06/13)
- Esercitazione 11: photos.webapp (it, 77 KB, 05/06/13)
- Esercitazione 1: esercizio (it, 42 KB, 06/03/13)
- Esercitazione 1: lucidi (it, 637 KB, 05/03/13)
- Esercitazione 2: esercizio (it, 123 KB, 20/03/13)
- Esercitazione 2: lucidi (it, 982 KB, 19/03/13)
- Esercitazione 3: esercizio (it, 81 KB, 26/03/13)
- Esercitazione 3: lucidi (it, 610 KB, 26/03/13)
- Esercitazione 4: esercizio (it, 69 KB, 27/03/13)
- Esercitazione 4: lucidi (it, 397 KB, 27/03/13)
- Esercitazione 5: esercizio (it, 52 KB, 03/04/13)
- Esercitazione 5: lucidi (it, 2032 KB, 03/04/13)
- Esercitazione 6: esercizio (it, 40 KB, 10/04/13)
- Esercitazione 6: lucidi (it, 1074 KB, 10/04/13)
- Esercitazione 6: tomcat (it, 41 KB, 10/04/13)
- Esercitazione 7: esercizio (it, 44 KB, 17/04/13)
- Esercitazione 7: lucidi (it, 657 KB, 17/04/13)
- Esercitazione 7: servlet con bean (it, 4 KB, 17/04/13)
- Esercitazione 7: servlet senza bean (it, 2 KB, 17/04/13)
- Esercitazione 8: corsi.jsp (it, 0 KB, 08/05/13)
- Esercitazione 8: esempiJSP (it, 1 KB, 08/05/13)
- Esercitazione 8: esercizio (it, 85 KB, 08/05/13)
- Esercitazione 8: lucidi (it, 766 KB, 08/05/13)
- Esercitazione 9: daFare.jsp (it, 0 KB, 22/05/13)
- Esercitazione 9: esercizio (it, 88 KB, 22/05/13)
- Esercitazione 9: lucidi (it, 520 KB, 21/05/13)
- Esercitazione 9: main.java (it, 3 KB, 22/05/13)
Type D and Type F activities
Modules not yet included
Career prospects
Module/Programme news
News for students
There you will find information, resources and services useful during your time at the University (Student’s exam record, your study plan on ESSE3, Distance Learning courses, university email account, office forms, administrative procedures, etc.). You can log into MyUnivr with your GIA login details: only in this way will you be able to receive notification of all the notices from your teachers and your secretariat via email and also via the Univr app.
Graduation
List of thesis proposals
theses proposals | Research area |
---|---|
Analisi e percezione dei segnali biometrici per l'interazione con robot | AI, Robotics & Automatic Control - AI, Robotics & Automatic Control |
Integrazione del simulatore del robot Nao con Oculus Rift | AI, Robotics & Automatic Control - AI, Robotics & Automatic Control |
Domain Adaptation | Computer Science and Informatics: Informatics and information systems, computer science, scientific computing, intelligent systems - Computer graphics, computer vision, multi media, computer games |
Domain Adaptation | Computer Science and Informatics: Informatics and information systems, computer science, scientific computing, intelligent systems - Machine learning, statistical data processing and applications using signal processing (e.g. speech, image, video) |
BS or MS theses in automated reasoning | Computing Methodologies - ARTIFICIAL INTELLIGENCE |
Domain Adaptation | Computing Methodologies - IMAGE PROCESSING AND COMPUTER VISION |
Domain Adaptation | Computing methodologies - Machine learning |
Dati geografici | Information Systems - INFORMATION SYSTEMS APPLICATIONS |
Analisi e percezione dei segnali biometrici per l'interazione con robot | Robotics - Robotics |
Integrazione del simulatore del robot Nao con Oculus Rift | Robotics - Robotics |
BS or MS theses in automated reasoning | Theory of computation - Logic |
BS or MS theses in automated reasoning | Theory of computation - Semantics and reasoning |
Proposte di tesi/collaborazione/stage in Intelligenza Artificiale Applicata | Various topics |
Proposte di Tesi/Stage/Progetto nell'ambito dell'analisi dei dati | Various topics |
Tutoring faculty members
Attendance modes and venues
As stated in the Teaching Regulations, attendance at the course of study is not mandatory.
Part-time enrolment is permitted. Find out more on the Part-time enrolment possibilities page.
The course's teaching activities take place in the Science and Engineering area, which consists of the buildings of Ca‘ Vignal 1, Ca’ Vignal 2, Ca' Vignal 3 and Piramide, located in the Borgo Roma campus.
Lectures are held in the classrooms of Ca‘ Vignal 1, Ca’ Vignal 2 and Ca' Vignal 3, while practical exercises take place in the teaching laboratories dedicated to the various activities.