To show the organization of the course that includes this module, follow this link 
Course organization
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.
| 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 |
See the general notes on the course.
