Basic notions on computer programming (only suggested).
Introduction to data management issues in information systems, project techniques, and data management technologies. Introduction to data protection issues in information systems and regulations governing the management of personal data. Students will train the mind to analyze and design enterprise data and manage them through a DBMS and will acquire the basics about security regulations 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. Access control. Introduction to the EU General Data Protection Regulation (GDPR).
Lectures and practical exercises in the lab with PCs.
Written test and optional oral test.
If it will be necessary to hold the course remotely or in a mixed way, the syllabus could be modified in order to make the course and the exams suitable for these teaching methods.