- Docente: Claudio Sartori
- Credits: 5
- SSD: ING-INF/05
- Language: Italian
- Teaching Mode: Traditional lectures
- Campus: Bologna
- Corso: First cycle degree programme (L) in STATISTICAL SCIENCES (cod. 8054)
Learning outcomes
The student learns the fundamental principles of the relational
data model and of the relational database management systems. In
particular, the student will be able to understand the structure of
a relational database, the integrity constraints on data and the
SQL query language.
Course contents
Database Management Systems: general architecture, relational data
model; normalization of relations and anomaly elimination. The SQL
query language, selection, join, grouping techniques. Principles of
physical organizations of data. Representation of information in
mass memory, characteristics of devices.
Problems related to data quality.
Problems related to database integration
Principles and examples of the software Relais (ISTAT) for the
record linkage
Readings/Bibliography
Paolo Atzeni, Stefano Ceri, Stefano Paraboschi, Riccardo Torlone, "Database Systems", McGraw-Hill, 1999.
Teaching methods
Classes, laboratory activity, witnesses from production and public
administration.
Assessment methods
In a lab session the teacher assigns the specifications for a
simple relational database and for some queries. The student is
requested to implement the specifications in MS Access
Teaching tools
Relational database systems: usage of open-source tools
Links to further information
http://www-db.deis.unibo.it/~csartori/didattica/00index.html
Office hours
See the website of Claudio Sartori