italian version

Aims :

To get aquainted with the basic concepts, methods and systems for the management of enterprise data sets of medium complexity.

Topics :

¦ Introduction to enterprise information systems:definitions of organization, information and computer systems. Enterprise processes. Processes, information and data.
¦ Database and database management systems: basic definitions, database schemes and instances, abstraction levels, abstraction and data independence. Languages for database management, Database users.
¦ Relational model: definition of relation, relations and tables, integrity constraints.
¦ Relational algebra.
¦ SQL.
¦ Database design.
¦ Conceptual design by the Entity/Relationship model.
¦ Logical design: translation from the E/R model to the relational model, normalization.
¦ Information systems for decision support: OLAP, datawarehouse, DSS, data mining.


Textbooks :

¦ P. Atzeni, S. Ceri, S. Paraboschi, R. Torlone, Basi di dati: modelli e linguaggi di interrogazione, McGraw-Hill, Italia, 2002
¦ P. Atzeni, S. Ceri, S. Paraboschi, R. Torlone, Basi di dati: architetture e linee di evoluzione, McGraw-Hill, Italia, 2002
¦ Other materials given by the teacher

Exam :

Design of a database of medium complexity. Written and oral examination.

Tutorial Session :

Monday, 10:00-11:00