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.
Study Plan
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/2026The 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.
1° Year
Modules | Credits | TAF | SSD |
---|
2° Year activated in the A.Y. 2016/2017
Modules | Credits | TAF | SSD |
---|
One course to be chosen among the following
2nd foreign language B1 (CB Test)
3° Year activated in the A.Y. 2017/2018
Modules | Credits | TAF | SSD |
---|
One course to be chosen among the following
One course to be chosen among the following
Modules | Credits | TAF | SSD |
---|
Modules | Credits | TAF | SSD |
---|
One course to be chosen among the following
2nd foreign language B1 (CB Test)
Modules | Credits | TAF | SSD |
---|
One course to be chosen among the following
One course to be chosen among the following
Modules | Credits | TAF | SSD |
---|
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.
Documental Information Technology (i) (2017/2018)
Teaching code
4S02218
Teacher
Coordinator
Credits
6
Language
Italian
Scientific Disciplinary Sector (SSD)
INF/01 - INFORMATICS
Period
First half of Semester 2 , Second half of Semester 2
Learning outcomes
The aim of the course is to describe the principal notions about data bases, focusing on design methodologies and query languages.
Program
Basic Requirements: Basic Information Technology
1. Introduction to Data Bases.
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, S. Paraboschi e R. Torlone. Basi di Dati: modelli e linguaggi di interrogazione. McGraw-Hill, 2013.
Author | Title | Publishing house | Year | ISBN | Notes |
---|---|---|---|---|---|
P. Atzeni, S. Ceri, P. Fraternali, S. Paraboschi e R. Torlone | Basi di dati - Modelli e linguaggi di interrogazione (Edizione 4) | McGraw Hill | 2013 | 978-88-386-6800-5 |
Examination Methods
Examination:
Written test. Twenty questions (both multiple choice and open answers).
Purposes:
to verify the student's theoretical knowledge on data base design and principles. In addition, to verify the student's pratical competences in solving exercises on data base design and queries.
It is possible to partecipate in every exam session as well as to refuse a positive evaluation (>18) and to partecipate in the next exam sessions (note: a refused positive evaluation will be considered irremediably lost)
Teaching materials e documents
-
Esercizi Interrogazioni AR e SQL (pdf, it, 86 KB, 11/6/17)
-
Esercizi Preparazione Esame (pdf, it, 185 KB, 5/28/18)
-
Rifermenti al libro di testo (A.A. 2017/18) (pdf, it, 86 KB, 5/28/18)