DATA BASES
BASI DI DATI
| A.Y. | Credits |
|---|---|
| 2025/2026 | 12 |
| Lecturer | Office hours for students | |
|---|---|---|
| Chiara Contoli | Wednesday, 11:00-13:00 |
| Teaching in foreign languages |
|---|
|
Course with optional materials in a foreign language
English
This course is entirely taught in Italian. Study materials can be provided in the foreign language and the final exam can be taken in the foreign language. |
Assigned to the Degree Course
| Date | Time | Classroom / Location |
|---|
| Date | Time | Classroom / Location |
|---|
Learning Objectives
The aim of this course is to introduce information systems, describe data models and conceptual, logical and physical design techniques for the development and management of databases. Secondly, it introduces the main methodologies for data mining.
Program
-- First semester --
01. Python
01.01 Introduction to the language
01.02 Python for data analysis
02. Data Analytics
02.01 Data mining
02.02 Data preparation
02.03 Clustering
02.04 Classification
02.05 Prediction
03. Applications and tools for data analysis
03.01 Python
03.02 Use cases
04. Introduction to the course: data and DBMS
04.01 Introduction to data management, data analysis, big data
04.02 Database definition
04.03 Introduction to the Data Base Management Systems (DBMS)
-- Second semester --
05. Models and Languages for Databases
05.01 Relational model
05.02 Database Management Systems (DMBS)
05.03 Integrity constraints, primary keys
06. SQL
06.01 DDL (Data Definition Language)
06.02 DML (Data Manipulation Language)
06.03 Nested queries
06.04 Operators, views, procedures, trigger
07. MySQL
07.01 Introduction
07.02 Lab
8. DB Design - Conceptual design
08.01 E/R model
08.02 Analysis
08.03 Design strategies
08.04 Quality verification
09. Logical design
09.01 E/R restructuring
09.02 Translation of the relational model
09.03 Quality assessment
10. Normalization
10.01 Data redundancies
10.02 Normal forms: Boyce-Codd, 3rd normal form
10.03 Decomposition algorithm
11. Physical design
11.01 Memory organization
11.02 Techniques for data management
11.03 Indexed Sequential Access Method (ISAM
Bridging Courses
It is suggested (not mandatory) to take the Database exam after courses on computer programming, computer architectures, algorithms and data structures, operating systems.
Learning Achievements (Dublin Descriptors)
Knowledge and understanding: the student will acquire the main knowledge related to database design methodologies, SQL query language, architecture of database management systems; he will be able to understand the structure of information systems designed according to the relational model. In addition, the student will acquire the main knowledge related to the extraction of information from data analysis.
Ability to apply knowledge and understanding: the student will be able to apply the acquired knowledge to design relational databases and implement them using systems such as MySQL. It will also be able to develop a project for the construction of an IT system. Finally, he will be able to understand and (partially) apply data mining techniques for extracting information from a set of raw data.
Autonomy of judgment: the student will be able to evaluate the correctness and efficiency of a database designed according to the relational model.
Teaching Material
The teaching material prepared by the lecturer in addition to recommended textbooks (such as for instance slides, lecture notes, exercises, bibliography) and communications from the lecturer specific to the course can be found inside the Moodle platform › blended.uniurb.it
Teaching, Attendance, Course Books and Assessment
- Teaching
Frontal lessons and laboratory activities
- Innovative teaching methods
- Attendance
Not mandatory
- Course books
Paolo Atzeni, Stefano Ceri, Stefano Paraboschi, Riccardo Torlone, Basi di dati - 5/ed, 2018, ISBN: 9788838694455
- Assessment
Project (possibly in group, max 2 people), to be decided with the teacher (score from 0 to 5)
Written exam (score from 0 to 30)
Oral exam: mandatory for the project discussion, optional on the program course (score from 0 to 5)
Intermediate evaluation: it consists of one (or few) scientific article reading to be discussed through an oral presentation (score from 0 to 3)
- Disability and Specific Learning Disorders (SLD)
Students who have registered their disability certification or SLD certification with the Inclusion and Right to Study Office can request to use conceptual maps (for keywords) during exams.
To this end, it is necessary to send the maps, two weeks before the exam date, to the course instructor, who will verify their compliance with the university guidelines and may request modifications.
Additional Information for Non-Attending Students
- Teaching
Material coming from frontal lessons and laboratory activities
- Attendance
Not mandatory
- Course books
Paolo Atzeni, Stefano Ceri, Stefano Paraboschi, Riccardo Torlone, Basi di dati - 5/ed, 2018, ISBN: 9788838694455
- Assessment
Project (possibly in group, max 2 people), to be decided with the teacher (score from 0 to 5)
Written exam (score from 0 to 30)
Oral exam: mandatory for the project discussion, optional on the program course (score from 0 to 5)
Intermediate evaluation: it consists of one (or few) scientific article reading to be discussed through an oral presentation (score from 0 to 3)
- Disability and Specific Learning Disorders (SLD)
Students who have registered their disability certification or SLD certification with the Inclusion and Right to Study Office can request to use conceptual maps (for keywords) during exams.
To this end, it is necessary to send the maps, two weeks before the exam date, to the course instructor, who will verify their compliance with the university guidelines and may request modifications.
| « back | Last update: 13/06/2025 |
