Teaching code

4S008227

Credits

12

Coordinatore

Carlo Combi

Language

Italian

Moodle Seminars

The teaching is organized as follows:

Learning outcomes

The course is aimed at providing concepts and methods for the design of biomedicine and bioinfor-matics databases. Moreover, the course is aimed at providing the basic notions of software engineer-ing, addressing in particular the different phases of the software development process. The course comprises two modules as detailed below: Module Basi di dati per Bioinformatica: This module has the aim to provide the students with the ne-cessary 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: (i) design and implement relational databa-ses; (ii) query relational databases. Module Riconoscimento e recupero dell’informazione per Bioinformatica: This module introduces the basic scientific and professional notions of software engineering, addressing in particular the different phases of the software development process: planning, design, modeling and specification, imple-mentation, testing and validation, evaluation, maintenance. The programming projects carried out in the lab complement the theory lectures with the design, documentation and realization of a software. At the end of the course, the students will have acquired all the basic knowledge related to software engineering and will be able to apply it in the design and implementation of software systems. They will also be able to interact with all the stakeholders, from the requirement elicitation to the software maintenance.

Program

------------------------
MM: INGEGNERIA DEL SOFTWARE
------------------------
see the corresponding module in "Programmazione II e Ingegneria del Software" in the Bachelor Degree in Computer Science.

------------------------
MM: BASI DI DATI PER BIOINFORMATICA
------------------------
- 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.

Bibliography

Examination Methods

------------------------
MM: INGEGNERIA DEL SOFTWARE
------------------------
see the info in corresponding module in "Programmazione II e Ingegneria del Software" of the Bachelor Degree in Computer Science.

------------------------
MM: BASI DI DATI PER BIOINFORMATICA
------------------------
To pass the exam, the students must show that: - they have understood the concepts related to the theory of relational databases and their design; - 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. The exam of Databases for bioinformatics consists of a written exam containing some questions about theory concepts, an exercise about the conceptual modeling (using the E-R model) and the logical modeling (using the relational model) of a database, and some exercises about the specification of queries in relational algebra on a given database.