Basic notions on computer programming (only suggested).
Introduction to data management problems in information systems, project techniques and data management technologies. Introduction to data protection issues in information systems and basic security and privacy techniques. Students will train the mind to analyze and design enterprise data and manage them through a DBMS and will acquire the basic notions about data protection and security in information systems.
Conceptual design: Entity-Relationship model.
Logic design: the relational data model.
Techniques for representing conceptual schemas into the relational data model.
Querying data: relational algebra.
The SQL language: simple queries, with selection, grouping and aggregate functions, different types of Join, and nested queries. Introduction to cryptography, symmetric and asymmetric cryptography. Access control. Introduction to the EU General Data Protection Regulation (GDPR).
Module of Databases
Atzeni, Ceri, Paraboschi, Torlone
Database Systems - Concepts, Languages and Architectures.
Lecture transparencies and slides.
Lectures and practical exercises in the lab with PCs.
Written test and optional oral test.