- Docente: Fabio Grandi
- Credits: 9
- SSD: ING-INF/05
- Language: Italian
- Teaching Mode: Traditional lectures
- Campus: Bologna
- Corso: First cycle degree programme (L) in Engineering Management (cod. 0925)
Learning outcomes
Aim of the course is to provide the methodological tools which are necessary for the correct design and use of an information system and for the development of applications on a relational DBMS platform, and to provide some knowledge of the base technologies which are deployed in their implementation.
Course contents
Enterprise Information Systems and Data Base Management Systems
(DBMS).
Introduction to the fundamental concepts on information systems
and relational data bases. Relational theory: basic definitions,
relational algebra, normal forms. The SQL language: DDL and DML.
Simple and complex queries (including grouping and nesting), views.
SQL for applications.
Technology of Relational Systems.
The control of concurrent accesses and the management of
transactions. Recovery of information after malfunctions. Advanced
architectures: parallelism, replication. Distributed data bases:
fragmentation, distributed transactions. Outline of physical
organization (B+tree indexes, join methods, optimization).
Design of Information Systems.
Analysis of enterprise organization, requirements collection.
The conceptual design of data: the Entity-Relationship model and
the data schemata. The flow and operation schemata: Data-Flow
Diagrams and Workflows. Design methodologies. Integrated design of
data and functions. relational logical design. Design with
ERP systems.
Readings/Bibliography
- P. ATZENI, S. CERI, S. PARABOSCHI, R. TORLONE, Databases, McGraw-Hill, second edition, 1999.
- F. GRANDI, Esercizi di Basi di Dati (in Italian), Esculapio, 2007.
- R. VAN DER LANS, Introduction to SQL, Addison-Wesley, 2001.
- L. BARESI, C. FRANCALANCI, F.A. SCHREIBER, L. TANCA, Progettazione Integrata di Dati e Funzioni (in Italian), Esculapio, 2003.
Teaching methods
Room lessons and exercises are given with the help of slides
(through overhead projector or PC+projector).
Students must prepare a project work (design of a relational
database), by applying the methodologies learned form the
lessons.
Assessment methods
The final exam is mainly made of a written test, containing theory
questions and practical exercises (SQL queries and
optimization).
The written test is passed if it receives a 18/30 score on a total
score of 33/30. Once the written test is passed, the student has to
take a final talk where the written test is discussed and the
project is evaluated.
Teaching tools
Downloadable informal notes (in Italian) on the course topics
are available.
Links to further information
http://www-db.deis.unibo.it/~fgrandi/didattica.html
Office hours
See the website of Fabio Grandi