The course is offered on the 2nd semester of the 1st year. The course presents database management systems and introduces the methodologies for the design, querying, and management of databases, introduction to business intelligence and the creation of interactive dashboards for data reporting. Laboratory sessions allow experimental activities on the most widespread commercial and open-source products.

- Knowledge of the main characteristics of a database management system - Knowledge of the structure and properties of the relational model - Knowledge of query languages for a relational database: SQL language - Ability to write queries in the SQL languages - Knowledge of the conceptual Entity-Relationship model for data representation and of the methodology for conceptual and logical design of a relational database - Ability to design a relational database - Knowledge of the interaction techniques between SQL statements and reporting tools - Ability to design and develop an interactive dashboard - Knowledge of fundamentals behind spatial databases

Basic programming skills.

- Characteristics of a database management system - Characteristics of the relational model - SQL language: statements for data definition and processing - Conceptual data model (Entity-Relationship) and methodology for the conceptual and logical design of a relational database - Introduction to Business intelligence: reporting environments for data analyses (query definition, generation of reports and interactive dashboards) - Introduction to spatial databases

The course includes lectures, whose topics are described earlier, and practice on the lecture topics. Students will prepare an individual written report on the exercises proposed during the course. The report will contribute to the final exam grade. The course includes laboratory sessions on some course topics (such as SQL language, the creation of a database using a Database Management System, the creation of interactive dashboards for data reporting). Laboratory sessions allow experimental activities on the most widespread commercial and open-source products for database systems.

The reference book, covering the majority of the course topics, is: Database Systems – Concepts, Languages and Architectures Paolo Atzeni, Stefano Ceri, Stefano Paraboschi and Riccardo Torlone McGraw-Hill. Copies of the slides used during the lectures, examples of written exams and exercises, and materials for the activities in the laboratory will be made available. All teaching material is downloadable from the course website or the Portal.

Slides; Libro di testo; Esercizi; Esercizi risolti; Esercitazioni di laboratorio; Esercitazioni di laboratorio risolte; Video lezioni dell’anno corrente; Strumenti di auto-valutazione;

Modalità di esame: Elaborato progettuale individuale; Prova scritta in aula tramite PC con l'utilizzo della piattaforma di ateneo;

Exam: Individual project; Computer-based written test in class using POLITO platform;

... The exam includes a written part, which lasts 90 minutes, and the evaluation of the reports on the individual practices assigned during the course. The delivery of the individual practices' reports is optional. The written part will assess the knowledge of the SQL language and the ability to write queries in the SQL language; the knowledge of the key aspects related to the design of relational databases; knowledge of some advanced aspects of databases design and query (such as spatial database, creating dashboards for reporting and for supporting decision making). The written part consists of close and open-ended questions (e.g., multiple-choice tests, open exercises). The points assigned to each exercise/question will be explicitly indicated next to the text of the exercise/question. Students are not allowed to use textbooks, notes, or additional electronic devices. The individual practice reports will assess the knowledge and ability of some course topics (such as the ability to write queries in SQL, the ability to design interactive dashboards to support decision making). The delivery of individual practices’ reports during the course is optional (max 3 points). The final exam grade is defined by considering the evaluation of the written part, and, optionally, of the individual practices. The individual practices are considered only if the grade of the written part is 18 or above.

Gli studenti e le studentesse con disabilità o con Disturbi Specifici di Apprendimento (DSA), oltre alla segnalazione tramite procedura informatizzata, sono invitati a comunicare anche direttamente al/la docente titolare dell'insegnamento, con un preavviso non inferiore ad una settimana dall'avvio della sessione d'esame, gli strumenti compensativi concordati con l'Unità Special Needs, al fine di permettere al/la docente la declinazione più idonea in riferimento alla specifica tipologia di esame.