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.

Type D and Type F activities

Le attività formative in ambito D o F comprendono gli insegnamenti impartiti presso l'Università di Verona o periodi di stage/tirocinio professionale.
Nella scelta delle attività di tipo D, gli studenti dovranno tener presente che in sede di approvazione si terrà conto della coerenza delle loro scelte con il progetto formativo del loro piano di studio e dell'adeguatezza delle motivazioni eventualmente fornite.

 

I semestre From 10/1/20 To 1/29/21
years Modules TAF Teacher
Matlab-Simulink programming D Bogdan Mihai Maris (Coordinator)
II semestre From 3/1/21 To 6/11/21
years Modules TAF Teacher
Introduction to 3D printing D Franco Fummi (Coordinator)
Python programming language D Vittoria Cozza (Coordinator)
HW components design on FPGA D Franco Fummi (Coordinator)
Rapid prototyping on Arduino D Franco Fummi (Coordinator)
Protection of intangible assets (SW and invention)between industrial law and copyright D Roberto Giacobazzi (Coordinator)
List of courses with unassigned period
years Modules TAF Teacher
Subject requirements: mathematics D Rossana Capuani
The fashion lab (1 ECTS) D Maria Caterina Baruffi (Coordinator)
LaTeX Language D Enrico Gregorio (Coordinator)

Teaching code

4S00012

Credits

6

Coordinator

Barbara Oliboni

Language

Italian

Scientific Disciplinary Sector (SSD)

INF/01 - INFORMATICS

The teaching is organized as follows:

Laboratorio
The activity is given by Databases - Laboratorio of the course: Bachelor's degree in Computer Science

Credits

3

Period

II semestre

Academic staff

Sara Migliorini

Teoria

Credits

3

Period

II semestre

Academic staff

Barbara Oliboni

Learning outcomes

The purpose of the course is to introduce the methodologies and technologies for the design and im-plementation of data-centric web sites, and the approaches specific to storage and query bioinfor-matics data. The course includes a lab module where students learn to working with a database management system and developing web applications exploiting databases. The students will learn how to use Python programming language, which is at the bases of the main technologies studied in the lab module.

Program

Theory Module
----------------------------------------------------------------
- The internal architecture of a database management system:
-- Sequential data structures and indexes (B-trees and hashing)
-- Transactions.
- Semistructured data models: XML for bioinformatics.


Laboratory Module
----------------------------------------------------------------
- Introduction to the relational database management system (RDBMS) PostgreSQL.
- Introduction to the use of SQL in PostgreSQL.
- Query Optimization.
- Introduction to the transaction.
- Database access from applications written in Java/Python.

Bibliography

Reference texts
Activity Author Title Publishing house Year ISBN Notes
Laboratorio Sara Migliorini Materiale fornito in laboratorio  
Teoria Paolo Atzeni, Stefano Ceri, Piero Fraternali, Stefano Paraboschi, Riccardo Torlone Basi di dati (Edizione 5) McGraw Hill 2018 9788838694455

Examination Methods

The exam is composed of two parts: theory and laboratory.

To pass the exam, the student must show that:
- they are able to apply the acquired knowledge to design and implement an application that interacts with a database;
- they are able to describe the concepts in a clear and exhaustive way;
- they are able to apply the acquired knowledge to solve application scenarios described by means of questions and exercises.

Theory Module
----------------------------------------------------------------
Written exam composed of questions and exercises on the theory topics.

Laboratory Module
----------------------------------------------------------------
Written exam composed of exercises on the theory topics.

Final grade will be the mean value of theory exam and lab exam grades.

Students with disabilities or specific learning disorders (SLD), who intend to request the adaptation of the exam, must follow the instructions given HERE