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.

Print / Share

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.

Academic calendar

Course calendar

The Academic Calendar sets out the degree programme lecture and exam timetables, as well as the relevant university closure dates..

For the year 2008/2009 No calendar yet available

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.

Exam calendar

Should you have any doubts or questions, please check the Enrolment FAQs

Academic staff

B C D F G M P S T V Z
Foto, May 6, 2009

Belussi Alberto

alberto.belussi@univr.it +39 045 802 7980
Nico, October 28, 2015

Bombieri Nicola

nicola.bombieri@univr.it +39 045 802 7094
Fotografia, September 2, 2021

Cristani Matteo

matteo.cristani@univr.it 045 802 7983
foto-ale, May 18, 2012

Di Pierro Alessandra

alessandra.dipierro@univr.it +39 045 802 7971
Foto, April 10, 2017

Drago Nicola

nicola.drago@univr.it 045 802 7081
Drioli Carlo

Drioli Carlo

carlo.drioli@univr.it +39 045 802 7968
Foto, February 18, 2016

Ferro Ruggero

ruggero.ferro@univr.it 045 802 7909
Fotografia, November 1, 2017

Fiorini Paolo

paolo.fiorini@univr.it 045 802 7963
Franco Fummi, November 15, 2021

Fummi Franco

franco.fummi@univr.it 045 802 7994
Foto, September 25, 2000

Fusiello Andrea

nome.cognome[at]uniud.it
Foto Lavagna, October 31, 2016

Giacobazzi Roberto

roberto.giacobazzi@univr.it +39 045 802 7995
Foto, February 28, 2018

Gregorio Enrico

Enrico.Gregorio@univr.it 045 802 7937
Massimo Guerriero, October 7, 2011

Guerriero Massimo

massimo.guerriero@univr.it
Foto_2015, July 24, 2015

Mariotto Gino

gino.mariotto@univr.it +39 045 8027031
foto 2013, June 13, 2013

Masini Andrea

andrea.masini@univr.it 045 802 7922
Gloria Menegaz, April 4, 2022

Menegaz Gloria

gloria.menegaz@univr.it +39 045 802 7024
Foto, August 20, 2021

Merro Massimo

massimo.merro@univr.it 045 802 7992
Francesca Monti, February 9, 2015

Monti Francesca

francesca.monti@univr.it 045 802 7910
Laura Morato, October 10, 2010

Morato Laura Maria

laura.morato@univr.it 045 802 7904
Foto_11_02_19, August 14, 2020

Pravadelli Graziano

graziano.pravadelli@univr.it +39 045 802 7081
Roberto Segala, January 20, 2015

Segala Roberto

roberto.segala@univr.it 045 802 7997
FotoCv, February 3, 2016

Stefanni Francesco

Todorov Velitchko

Todorov Velitchko

velitchko.todorov@univr.it
Venturin Manolo

Venturin Manolo

Luca Vigano`, October 7, 2007

Vigano' Luca

luca.vigano@univr.it
Zoccante Sergio

Zoccante Sergio

sergiozoccante@tin.it

Study 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 enrolment year.

Training offer to be defined

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.

A Basic activities
B Characterizing activities
C Related or complementary activities
D Activities to be chosen by the student
E Final examination
F Other training activities
SPlacements in companies, public or private institutions and professional associations

Databases (2010/2011)

Teaching code

4S00037

Credits

12

Also offered in courses

Also offered in courses

Language

Italian

Scientific Disciplinary Sector (SSD)

INF/01 - INFORMATICS

Seminars

The teaching is organized as follows:

Teoria

Credits

9

Period

II semestre, I semestre

Academic staff

Alberto Belussi

Laboratorio

Credits

3

Period

II semestre

Academic staff

Alberto Belussi

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)
11. JSP and servlet: a software architecture base on the Model View Controller approach.
12. Servlet/JSP and multimedia datasets.

Bibliography

Reference texts
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 (Edizione 2) McGraw-Hill 2007 978-88-386-6370-3
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

Type D and Type F activities

Training offer to be defined

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.

MyUnivr

Further services

I servizi e le attività di orientamento sono pensati per fornire alle future matricole gli strumenti e le informazioni che consentano loro di compiere una scelta consapevole del corso di studi universitario.


Graduation

List of theses and work experience 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 delle basi di dati/sistemi informativi Various topics

Attendance

As stated in point 25 of the Teaching Regulations for the A.Y. 2021/2022, attendance at the course of study is not mandatory.
Please refer to the Crisis Unit's latest updates for the mode of teaching.

Career management


Area riservata studenti