COMPUTER, ELECTRONIC AND COMMUNICATIONS ENGINEERING

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

lectures timetable

exam calls

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

No particular requirement. Fundamental knowledge of computer science and basic programming.

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 skills needed for the practice will be acquired in labs.

Assessment methods and criteria

A two-hour written exam, where the student will be asked to answer basic questions on db theory, write some SQL queries, and design a reduced-size database.

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

- - -

2030 agenda goals for sustainable development

- - -

Contacts

Toll-free number

800 904 084

Student registry office

E. segreteria.ingarc@unipr.it

Quality assurance office

Education manager:
Elena Roncai
T. +39 0521 903663
Office E. dia.didattica@unipr.it
Manager E. elena.roncai@unipr.it

DATABASES cod. 09178

Learning objectives

Prerequisites

Course unit content

Full programme

Bibliography

Teaching methods

Assessment methods and criteria

Other information

2030 agenda goals for sustainable development

Contacts

Toll-free number

Student registry office

Quality assurance office

President of the degree course

Faculty advisor

Career guidance delegate

Tutor professor

Erasmus delegates

Quality assurance manager

Tutor students

DATABASES
cod. 09178