Learn how to design databases, in particular relational, to support applications or adapt existing databases to the needs of new applications that have to interact with them; how to express queries and changes on relational databases and acquire the basic principles relating to internal organization and administration of data management systems - with specific reference to physical schema design, performance monitoring, concurrent execution of transactions and access control.
DESCRIBE the different phases in the design of relational databases, the data models used at both a conceptual and logical level, the design techniques used in the various phases.
UNDERSTAND how to check the quality of the proposed schemes, how to possibly improve them by eliminating redundancies and anomalies.
USE the techniques proposed for the design of a relational database to support an application, starting with user requirements.
UNDERSTAND how to express queries and modifications on relational databases.
DESCRIBE the constructs of relational languages (relational algebra and SQL) and their properties
USE relational languages (algebra and SQL) to query a database, SQL to express data manipulation operations and establish integrity constraints on data
ONLY 12 CFU:
USE the SQL language to express complex operations through functions and procedures, to express complex integrity constraints and operational rules through triggers
UNDERSTAND the basic principles relating to the internal organization and administration of data management systems, with specific reference to the design of the physical scheme, performance monitoring, transaction execution and access control.
ANSWER questions on the basic principles relating to the internal organization and administration of data management systems.
TRANSVERSAL OUTCOMES:
thanks to the participation in the planned teaching activities, at the end of the course the students will also be able to:
- communicate effectively in written and oral form, adapting one's communication to the context, using sources and aids of various kinds
- identify one's own abilities, developing the ability to concentrate and reflect critically on a task
- manage their social interactions with a collaborative attitude, constructive communication, in different environments
- demonstrate decision-making autonomy, collaborative attitude, management of human and material resources, coordination, negotiation skills, management of uncertainty.
Students who participate in optional educational activities (peer evaluation), will also be able to
- apply critical thinking, use, process and evaluate information, argue
- manage their own social interactions, develop a collaborative attitude, respecting others and their needs, and willingness to overcome prejudices, express and understand different points of view, manage conflict, build trust, empathy
- be aware of one's own learning strategies, organize and evaluate personal learning according to what is understood and learned, understand one's own needs and ways of developing skills, identify and pursue learning objectives
UNDERSTAND the basic principles relating to the internal organization and administration of data management systems, with specific reference to the design of the physical scheme, performance monitoring, concurrent execution of transactions and access control.
- be aware of one's own learning strategies, organize and evaluate personal learning according to what is understood and learned, understand one's own needs and ways of developing skills, identify and pursue learning objectives.
Basics of: first-order logic, set theory, syntax and semantics of a language, programming, computer architecture and operating systems.
Balancing among frontal lessons (with the use of instant polling), classroom exercises with Think-Pair-Share methodology, laboratory exercises in groups, using a relational data management system and supplementary activities using AulaWeb. For the database design part, a peer review activity is proposed in groups, with optional participation.
For everyone:
For 12 CFU:
Barbara Catania, Giovanna Guerrini, Elena Ferrari. Sistemi di Gestione Dati - Concetti e Architetture. CittaStudi Edizioni, Utet Libreria, De Agostini Scuola, 2006.
Barbara Carminati, Anna Maddalena, Marco Mesiti. Sistemi di Gestione Dati - Esercizi. CittaStudi Edizioni, Utet Libreria, De Agostini Scuola, 2008.
Ricevimento: Appointment by email or by Microsoft Teams Office: Valle Puggia – 301
Ricevimento: Appointment by email or by Microsoft Teams Office: Valle Puggia – 327
GIOVANNA GUERRINI (President)
DANIELE D'AGOSTINO
BARBARA CATANIA (President Substitute)
The exam consists of the following parts:
Details on how to prepare for the exam for each topic will be given during the lessons.
The written exam consists of
a set of closed-ended questions on basic course topics. The objective of these questions is to ascertain an understanding of the main issues faced during the lessons.
a design exercise. The objective of this exercise is to verify that the student knows how to use the data models and the design methodology presented during the course.
query specification exercises. The objective of these exercises is to verify that the student is able to formulate queries in the languages (relational algebra and SQL) addressed during the course.
