DATABASES
cod. 09178

Academic year 2023/24
3° year of course - Second semester
Professor
- Stefano CAGNONI
Academic discipline
Sistemi di elaborazione delle informazioni (ING-INF/05)
Field
Ingegneria informatica
Type of training activity
Characterising
48 hours
of face-to-face activities
6 credits
hub: PARMA
course unit
in ITALIAN

Learning objectives

The goal of the course is the analysis of the fundamental aspects of data management, database management systems, and database design methodologies (following the relational data model), both from a theoretical and practical perspective.

At the end of the course, students will be able to employ and deploy techniques and methods for database design, as well as to interact, use and manage the different tools offered by a database management system.

Prerequisites

- - -

Course unit content

Introduction to Databases
Relational Data Model
SQL
Database Design
Normalization
Transactions
NoSQL Databases

Full programme

- - -

Bibliography

Atzeni, Ceri, Fraternali, Paraboschi, Torlone
"Basi di dati (5ed.)"
McGraw-Hill Italia, 2018

Teaching methods

The theoretical aspects will be covered during the lectures; the technical aspects will be approached via exercises in the lab.

Assessment methods and criteria

A two-hour written exam, where the student will be asked to develop a reduced-size database and answer some other questions on the content of the course.

The written test is divided into two sections that can be solved contextually or singularly in each examination session.

Bonus points can be acquired by developing a complementary non-mandatory practical project.

Other information

- - -