Studying at the University of Verona

Here you can find information on the organisational aspects of the Programme, lecture timetables, learning activities and useful contact details for your time at the University, from enrolment to graduation.

This information is intended exclusively for students already enrolled in this course.
If you are a new student interested in enrolling, you can find information about the course of study on the course page:

Laurea in Scienze della comunicazione - Enrollment from 2025/2026

The Study Plan includes all modules, teaching and learning activities that each student will need to undertake during their time at the University.
Please select your Study Plan based on your enrollment year.

2° Year  activated in the A.Y. 2021/2022

ModulesCreditsTAFSSD
Foreign language B1 level (CB Test)
6
E
-
activated in the A.Y. 2021/2022
ModulesCreditsTAFSSD
Foreign language B1 level (CB Test)
6
E
-
Modules Credits TAF SSD
Between the years: 1°- 2°- 3°
Between the years: 1°- 2°- 3°
Other actvities
6
F
-

Legend | Type of training activity (TTA)

TAF (Type of Educational Activity) All courses and activities are classified into different types of educational activities, indicated by a letter.




S Placements in companies, public or private institutions and professional associations

iIntroductory
padvanced
mMasterful

Teaching code

4S02218

Credits

6

Language

Italian

Scientific Disciplinary Sector (SSD)

INF/01 - INFORMATICS

Period

2 A, 2 B

Learning outcomes

The aim of the course is to describe the principal notions about data bases, focusing on design methodologies and query languages. More specifically, the course aims to introduce problems about data conservation and management, as a precious and central resource of any human activity. Thanks to formal methods and a problem solving perspective, the student will acquire the basic skills to deal with data management in specific work or research situations, as well as the basics for data design through ad hoc softwares.

Program

• Basic Requirements: Basic Information Technology



1. Introduction to Databases.

2. Relational models: relations, keys and constraints.

3. Relational Algebra: selection, projection, join and set operators.

4. SQL language: data definition, data manipulation and queries.

5. E-R (Entity-Relationship) model: entities, relations, attributes.

6. Data Base design: conceptual design, logic design; E-R schema reorganization; translation from E-R schemas to relation models.


Course book:

P. Atzeni, S. Ceri, P. Fraternali, S. Paraboschi e R. Torlone. Basi di Dati. McGraw-Hill, 2018. ISBN-13 ‏ : ‎ 978-8838694455

Bibliography

Visualizza la bibliografia con Leganto, strumento che il Sistema Bibliotecario mette a disposizione per recuperare i testi in programma d'esame in modo semplice e innovativo.

Examination Methods

Examination:

Written test.
Questions could be with multiple choices and open answers.

Purposes:

To verify the student's theoretical knowledge on database design and principles. In addition, to verify the student's pratical competences in solving exercises on database design and queries.


It is possible to partecipate in every exam session.
It is also allowed to refuse a positive evaluation ( >= 18 ) and to partecipate in the next exam sessions (note: a refused positive evaluation will be considered irremediably lost)

Students with disabilities or specific learning disorders (SLD), who intend to request the adaptation of the exam, must follow the instructions given HERE