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