CODE 65920 ACADEMIC YEAR 2025/2026 CREDITS 6 cfu anno 2 INGEGNERIA INFORMATICA 8719 (L-8) - GENOVA SCIENTIFIC DISCIPLINARY SECTOR ING-INF/05 LANGUAGE Italian (English on demand) TEACHING LOCATION GENOVA SEMESTER 2° Semester MODULES Questo insegnamento è un modulo di: BASI DI DATI E SISTEMI OPERATIVI TEACHING MATERIALS AULAWEB OVERVIEW The course provides basic skills on the design of information systems and on the conceptual, logical and physical structure of relational databases AIMS AND CONTENT LEARNING OUTCOMES This teaching unit introduces database design and their lifecycle, the tools for their design, the languages for the creation, querying, and manipulation of centralized databases, and the fundamentals of relational databases. AIMS AND LEARNING OUTCOMES Enrolled students will be able to apply the acquired knowledge through the design of simple relational databases and queries. The design will focus on the Entity-Relation model (ER), while SQL will be used to formulate queries. Also, the course will provide a minimal introduction to the Python programming language to integrate the learned concepts and integrate databases inside applications. PREREQUISITES Knowledge of the fundamentals of programming and notions of mathematical analysis TEACHING METHODS In-person classes with slides-aided explanations. Programming exercises with both SQL and Python. Students with valid certifications for Specific Learning Disorders (SLD), disabilities, or other special educational needs are invited to contact the instructor and the Politecnica School's disability representative, Prof. Federico Scarpa (federico.scarpa@unige.it), at the beginning of the course. This will allow them to discuss and agree upon any necessary teaching adjustments that, while respecting the course objectives, take individual learning styles into account. SYLLABUS/CONTENT Architectures of modern databases Entity-Relation model: implementation of tables and queries using SQL Design of tables through the ER model, and translation into the logic model Queries with SQL and integration with Python RECOMMENDED READING/BIBLIOGRAPHY Ramez Elmasri, Shamkant B. Navathe, Sistemi di Basi di Dati - Fondamenti e Complementi ,7/E, Pearson, 2018. All the provided material will be shared on Aulaweb. Notes taken during class are sufficient to prepare the exam. TEACHERS AND EXAM BOARD FABIO ROLI Ricevimento: Contact the instructor by email. www.saiferlab.ai/people/fabioroli LUCA DEMETRIO Ricevimento: Contact the instructor by email. www.saiferlab.ai/people/lucademetrio LESSONS LESSONS START https://corsi.unige.it/corsi/8719/studenti-orario Class schedule The timetable for this course is available here: Portale EasyAcademy EXAMS EXAM DESCRIPTION Evaluations during the semester (closed-book exams with questions and programming exercises), or final written exam plus optional oral exam. Valutazioni in classe durante il semestre (soluzione a libro chiuso di esercizi numerici/programmazione e domande a risposta aperta), oppure esame scritto finale ed orale facoltativo. ASSESSMENT METHODS Solving exercises requiring the design of conceptual and logical schemas, loading data into a database, querying databases and presentation of the results of the queries. FURTHER INFORMATION Contact the teachers of the course to ask for more informatio. Agenda 2030 - Sustainable Development Goals Gender equality Decent work and economic growth Industry, innovation and infrastructure Reduce inequality Responbile consumption and production