DATABASES

Course objectives

General Objectives: The aim of the course is the presentation of the fundamental database principles and the corresponding management systems. The topics are presented from various points of view, covering theoretical, methodological, technological and application aspects. At the end of the course the student should have acquired not only the theoretical knowledge on the subject treated, but also the sufficient methodological techniques and tools to address a complete database project. Specific objectives: Knowledge and understanding: The main models and languages for the design and management of databases. Apply knowledge and understanding: Being able to design a database starting from the requirements by defining the conceptual schema completed with appropriate constraints; translate this schema into a logical model and implement it on a relational DBMS, equipped with relevant queries. Critical and judgment skills: Being able to evaluate the quality of a database project and the correctness of the applications used in its management. Communication skills: The project activities and the course exercises allow the student to be able to communicate / share the requirements of a database, as well as the design choices and the development methods. Learning ability: In addition to the classic learning skills provided by the theoretical study of the recommended material, the course structure, in particular the project activities, stimulates the students to deepen their knowledge of the topics, working in team, and to practically apply the concepts and techniques learned during the course.

Channel 1
TIZIANA CATARCI Lecturers' profile

Program - Frequency - Exams

Course program
Database management systems. The relational model. Relational query languages. SQL. Conceptual modeling. Logical modeling.
Prerequisites
Standard curricular knowledge of the degree
Books
R. Ramakrishnan, J. Gehrke. Sistemi di Basi di Dati. McGraw-Hill College Custom Series, 2004.
Frequency
Bi-weekly. Attendance strongly recommended
Exam mode
Written test containing the design of a simple database, the formulation of queries in SQL and a theory question.
Lesson mode
Lectures and classroom exercises
FEDERICO SCAFOGLIERI Lecturers' profile
Channel 2
FRANCESCO LEOTTA Lecturers' profile

Program - Frequency - Exams

Course program
Preliminar notions - information systems, databases, database management systems The relational model Relational Algebra The SQL language Definition and manipulation of data in SQL Nested queries in SQL Check constraints, assertions and view Conceptual design Logical design
Prerequisites
No previous knowledge required but basic knowledge of computer usage
Books
R. Ramakrishnan, J. Gehrke. Sistemi di basi di dati. McGraw-Hill, 2004. P.Atzeni, S.Ceri, S.Paraboschi, R.Torlone. Basi di Dati. Modelli e Linguaggi di Interrogazione. McGraw-Hill, 2014.
Frequency
No mandatory participation to lessons is required.
FEDERICO SCAFOGLIERI Lecturers' profile
  • Lesson code1017397
  • Academic year2024/2025
  • CourseManagement Engineering
  • CurriculumIngegneria Gestionale (percorso valido anche ai fini del conseguimento del doppio titolo italo-venezuelano)
  • Year3rd year
  • Semester1st semester
  • SSDING-INF/05
  • CFU6
  • Subject areaIngegneria informatica