Teaching code

4S004549

Credits

12

Coordinator

Carlo Combi

Language

English

Scientific Disciplinary Sector (SSD)

INF/01 - INFORMATICS

Courses Single

Authorized

Moodle Seminars 0

The teaching is organized as follows:

Learning objectives

Knowledge and understanding: The goal of this course is to provide the student with the knowledge and understanding of the theoretical, methodological and technological main concepts related to database systems and their use for the management of biomedical and bioinformatics data and information. Applying knowledge and understanding: The student will be able to a) define through a formal model the structure and the features of complex data collections; b) specify queries on complex data through different query languages; c) understand the advanced requirements for the management of biomedical information. Making judgements: The student will acquire the capability of autonomously evaluate different design options for complex systems, and of autonomously propose effective solutions in the application domain related to biomedicine and bioinformatics. Communication: The student will be also able to interact with different stakeholders in multidisciplinary teams, having different skills and backgrounds in biomedicine and bioinformatics. Lifelong learning skills: The student will acquire the capability of learning new methodologies and technologies related to data management and applying them in the biomedical/bioinformatics domain.

Prerequisites and basic notions

Basics of database systems.

Program

------------------------
MM: Fundamentals of database systems - Theory
------------------------
- The relational data model: relational calculus, functional dependencies, normal forms and decompositions.
- Conceptual data modeling with ER and UML
- Object and object-relational databases: data model and query language of SQL 3, ER/UML for modeling object-oriented databases, mapping towards SQL3 3.
------------------------
MM: Fundamentals of database systems Lab.
------------------------
- training on SQL 3 with postgreSQL
------------------------
MM: Biomedical and bioinformatics data management
------------------------
* Electronic Medical Record systems
* Temporal databases: basic concepts, data models, query languages (TSQL2, SQL:2011).
* Temporal Clinical Databases
* Querying biomedical XML data: Xpath and Xquery
* Information retrieval techniques in Medicine

Bibliography

Didactic methods

Lessons, exercises, and lab activities

Learning assessment procedures

------------------------
MM: Fundamentals of database systems Theory
------------------------
The exam for this module consists of a written test of up to 2.5 hours containing: (i) some exercises requiring the specification of queries and database design using one of the database models included in the program and (ii) open questions about the theory. A discussion with the candidate will follow, related to the written exam.
------------------------
MM: Fundamentals of database systems Lab.
------------------------
See the description of the theory module
------------------------
MM: Biomedical and bioinformatics data management
------------------------
The exam consists of oral exercises and questions related to the different parts of the module, intending to verify whether the student is aware of the theoretical content of the module and can apply it in real-world contexts.

Evaluation criteria

Correctness of the written answers (the rank of each exercise is explained in the text)
Clarity, completeness, and depth of the oral answers and of the exercise solution

Criteria for the composition of the final grade

Average of results from the written and the oral parts.

Exam language

Inglese

Sustainable Development Goals - SDGs

This initiative contributes to the achievement of the Sustainable Development Goals of the UN Agenda 2030. More information on sustainability