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
Database Technologies
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 three-hour written exam, where the student will be asked to develop a database of reduced size and to answer some other queries on the content of the course.
There might be an oral exam if deemed necessary by the teacher.
Other information
- - -
