Data management and retrieval for bioinformatics - BASI DI DATI PER BIOINFORMATICA (2019/2020)

Course code
Name of lecturer
Barbara Oliboni
Number of ECTS credits allocated
Academic sector
Language of instruction
I semestre dal Oct 1, 2019 al Jan 31, 2020.

To show the organization of the course that includes this module, follow this link * Course organization

Lesson timetable

Go to lesson schedule

Learning outcomes

This course has the aim to provide the students with the necessary concepts and methods for the design of a database and its applications, with an emphasis on the management of bioinformatics data.
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.

At the end of the course, the students will be able to understand how a database management system works and they will know how to:
- design and implement relational databases;
- query relational databases.


- Introduction to database management systems (DBMS).
-- Architectures and functionalities of a DBMS.
- Data models for database systems.
-- The relational data model.
--- Elements of the relational data models: relations and integrity constraints.
- Relational algebra.
- The SQL language.
-- SQL data definition.
-- SQL: select-from-where statement.
-- Join in SQL, the GROUP BY and ORDER BY clauses, using subqueries.
-- Views.
- Database design.
-- The methodology.
-- Conceptual database design.
--- The Entity-Relationship (E-R) data model.
--- Conceptual schema of a database.
- Logical database design.
-- Translating conceptual schemata in relational schemata.
-- The logical schema of a database.

Reference books
Author Title Publisher Year ISBN Note
Paolo Atzeni, Stefano Ceri, Piero Fraternali, Stefano Paraboschi, Riccardo Torlone Basi di dati (Edizione 5) McGraw Hill 2018 9788838694455

Assessment methods and criteria

See the general notes on the course.