You are here: Home » Study Plan » Subject


Subject: DATABASES (A.A. 2023/2024)


Course year 2
Teaching units Unit basi di dati
Computer Engineering (lesson)
  • TAF: Compulsory subjects, characteristic of the class SSD: ING-INF/05 CFU: 9
Exam type written
Evaluation final vote
Teaching language Italiano
Contents download pdf download




The aim of the course is to provide the fundamental notions of conceptual and logical models for relational databases; to acquire the capability ability to design, create, modify, and query a database.

Admission requirements

mandatory introductory courses: none

Course contents

Database Design and Models (20 hours - 2.5 CFU)
1.1 Conceptual Design: the Entity/Relationship Model.
1.2 Logical Design: the Relational Model.

Relational Theory and Languages (28 hours - 3.5 CFU)
1.3 Relational Algebra.
1.4 The SQL92 query language.
1.5 Introduction to functional dependencies and normalization theory.
1.6 Generalities on Database Management Systems (DBMS). Three Levels (ANSI/X3/Sparc) DBMS architecture; Relational DBMS architecture.

2 Practical Exercise in the laboratory (24 hours - 3 CFU)
2.1 Introduction to PostgreSQL environment. Notions on data import and export. Graphical tools for building databases: introduction to pgAdmin.
2.2 Core elements of a database. Creating, modifying, and deleting a database and its tables. Defining and updating constraints. Data manipulation: INSERT, UPDATE, and DELETE commands.
2.3 Creating queries on a database. Complex queries: joins and subqueries, derived tables. NULL values and their treatment.
2.4 Complex structure elements: Views, indexes.
2.5 Stored procedures and triggers

Teaching methods

Lectures, practical exercises, laboratory activities. Synchronous remote delivery for all will be guaranteed; on the basis of the evolution of the COVID19 health emergency and the specificities of the educational activities, the provision will also be assessed even in the presence. teaching platform Teams

Assessment methods

--- METHOD AND CONTENTS OF THE EXAMINATION --- The exam consists of a written test, a laboratory test and an optional oral test.

Learning outcomes

Knowledge and understanding: Through lectures, students will get a comprehensive knowledge and understanding of the relational database theory, the collection and analysis of requirements, the methodologies for conceptual and logical design, the query techniques.

Applying knowledge and understanding: Through classroom exercises and practical exercises on the computer, the student will be able to apply the knowledge gained in the design and implementation of a database.

Making judgments: Thanks to the resolution of individual exercises and practical exercises in the laboratory, the student will be able to critically evaluate the design and implementative decisions taken and the results obtained.

Communication skills: The design and open-ended questions of the written examination and the eventual oral examination, will equip the student to organize and clearly present, through the technical language, the results of his work.

Learning skills: The activities carried out during the course and during the examination allow the student to acquire the instruments to autonomously upgrade his knowledge. This is especially crucial in the field of data management, where technology is constantly evolving.