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.
Study Plan
This information is intended exclusively for students already enrolled in this course.If you are a new student interested in enrolling, you can find information about the course of study on the course page:
Laurea in Bioinformatica - Enrollment from 2025/2026The 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. 2017/2018
| Modules | Credits | TAF | SSD |
|---|
3° Year activated in the A.Y. 2018/2019
| Modules | Credits | TAF | SSD |
|---|
One course to be chosen among the following2 courses to be chosen among the following| Modules | Credits | TAF | SSD |
|---|
| Modules | Credits | TAF | SSD |
|---|
| Modules | Credits | TAF | SSD |
|---|
One course to be chosen among the following2 courses to be chosen among the followingLegend | 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 and WEB (2018/2019)
Teaching code
4S00012
Credits
6
Language
Italian
Scientific Disciplinary Sector (SSD)
INF/01 - INFORMATICS
The teaching is organized as follows:
Laboratorio
Teoria
Learning outcomes
------------------------
MM: Teoria
------------------------
After an introduction of the basic concepts of computer networks, the course will deal with methodologies and technologies for the design and implementation of data-centric web sites, with an emphasis on the storage and query of bioinformatics data.
------------------------
MM: Laboratorio
------------------------
The aim of this module is to provide the student with the necessary concepts and methods for working with a database management system and developing web applications exploiting databases. The main technologies considered during the course are based on Python language. Python will be introduced during the course. To attend the course in a productive way, students have to be confident with object-oriented programming.
Program
------------------------
MM: Teoria
------------------------
* The internal architecture of a database management system: the relevance of transactional systems. -- The ACID transaction properties. -- Physical data organisation: sequential data structures and indexes (B-trees and hashing). * Data centric web applications and bioinformatics. -- Basic concepts of computer networks. -- Semistructured data models; XML for bioinformatics. -- Interaction of web servers and data base management systems. -- Design methodologies for data-centric web applications. -- Design of data-centric web-based bioinformatics applications.
------------------------
MM: Laboratorio
------------------------
- Introduction to the relational database management system (RDBMS) PostgreSQL. - Introduction to the use of SQL in PostgreSQL. - Query Optimization. - Introduction to the transaction. - Introduction to Python Language. - Database access from applications written in Java/Python. - Introduction to Flask (Python) micro framework for developing simple database-based web applications. Teaching methods: Lecturing and practicing in a computer laboratory. Didactical material (slides) and further exercise texts are available on the eLearning platform. The teacher is available for individual meeting in office hours.
Bibliography
| Activity | Author | Title | Publishing house | Year | ISBN | Notes |
|---|---|---|---|---|---|---|
| Laboratorio | Autori Vari | Flask (http://flask.pocoo.org/) | Flask | 2016 | ||
| Laboratorio | Autori Vari | Manuale di Postgresql (https://www.postgresql.org/docs/) | Postgresql | |||
| Teoria | P. Atzeni, S. Ceri, P. Fraternali, S. Paraboschi, R. Torlone | Basi di dati (Edizione 4) | McGraw-Hill | 2014 | 978-88-386-6587-5 | |
| Teoria | DISPENSE | Dispense fornite dal docente | 2015 | |||
| Teoria | Andrew S. Tanenbaum, David J. Wetherall | Reti di calcolatori (Edizione 5) | Pearson | 2018 |
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 describe the concepts in a clear and exhaustive way without digressions
- they are able to apply the acquired knowledge to solve application scenarios described by means of exercises, questions and projects.
Module of Theory
----------------------------------------------------------------
For this module the exam consists of a written test with a duration of 1 hour containing: some questions and exercises on the theory topics.
Module of Laboratorio
---------------------------------
The examination consists of a written test containing 5 exercises based on the module program.
A student who obtains less than 13/30 in a written exam, will also have to take an oral examination once it has passed the written exam obtaining 18/30 at least. The final grade will be the average of two grades.
The grade in this module is worth 1/2 of the grade in the course examination.
A selection of previous exam tests is published at http://profs.scienze.univr.it/~posenato/courses/labBD/raccoltaTemiEsameLaboratorioBasiDatiDal2016.pdf
