Program Overview

---

Introduction to the BASI DI DATI Program

The BASI DI DATI program is designed to provide students with the fundamental knowledge and skills necessary for the design of informational systems and the conceptual, logical, and physical structure of relational databases.

Program Details

• Code: 65920
• Academic Year: 2025/2026
• CFU: 6 cfu, year 2, INGEGNERIA INFORMATICA 8719 (L-8) - GENOVA
• Scientific Disciplinary Sector: ING-INF/05
• Language: Italiano (Inglese a richiesta)
• Location: GENOVA
• Period: 2° Semestre
• Modules: This course is a module of: BASI DI DATI E SISTEMI OPERATIVI
• Teaching Materials: AULAWEB

Presentation

The program aims to introduce students to the design of informational systems and the structure of relational databases, focusing on their conceptual, logical, and physical aspects.

Objectives and Contents

Educational Objectives

The program introduces students to the design of databases and their life cycle, tools for their design, languages for the creation, interrogation, and manipulation of centralized databases, and relational databases.

Detailed Educational Objectives and Learning Outcomes

Students will be able to apply the acquired knowledge through the design of simple relational database schemes and their queries, using the Entity-Relationship (ER) model for design and SQL language for query formulation. Additionally, a basic understanding of the Python language will be provided to integrate the acquired notions into more complex applications.

Prerequisites

Knowledge of programming fundamentals and mathematical analysis notions.

Teaching Methods

Frontal lessons where the teacher uses slides, copies of which will be provided to students through Aulaweb. Design and programming exercises with SQL and Python languages.

Program Content

1. Architecture of Modern Databases
2. The Relational Model: Definition of tables and queries using relational algebra and SQL language.
3. Conceptual Design through the ER Model and Translation into the Logical Model.
4. Queries with SQL Language and Integration of Database Use through Python Language.

Texts/Bibliography

• Ramez Elmasri, Shamkant B. Navathe, Sistemi di Basi di Dati - Fondamenti e Complementi, 7/E, Pearson, 2018.
• All slides used during lessons and other teaching materials will be available on Aulaweb. Generally, notes taken during lessons and material on Aulaweb are sufficient for exam preparation.

Teachers and Commissions

• FABIO ROLI
• LUCA DEMETRIO

Examination Commission

• FABIO ROLI (President)
• LUCA DEMETRIO (Supplementary President)
• ANTONIO SGORBISSA (Supplementary President)

Lessons

Start of Lessons

The schedule for this course is consultable at the EasyAcademy portal.

Exams

Examination Methods

In-class evaluations during the semester (solution of numerical exercises/programming and open-answer questions), or a final written exam and optional oral exam.

Assessment Methods

Solution of exercises on the conceptual and logical design of a relational database, loading data contained in files into the database, querying the database, and presenting the data obtained from the queries.

Exam Calendar

Exam Date	Time	Location	Type	Notes
09/06/2026	15:00	GENOVA	Written
08/07/2026	10:00	GENOVA	Written
16/09/2026	10:00	GENOVA	Written

Additional Information

For other information, contact the teacher by email.

Agenda 2030

Gender Equality

Decent Work and Economic Growth

Industry, Innovation, and Infrastructure

Reduced Inequalities

Responsible Consumption and Production