- Docente: Fabio Grandi
- Credits: 9
- SSD: ING-INF/05
- Language: Italian
- Moduli: Fabio Grandi (Modulo 1) Fabio Grandi (Modulo 2)
- Teaching Mode: Traditional lectures (Modulo 1) Traditional lectures (Modulo 2)
- 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 necessaryfor the correct design and use of an information system and forthe development ofapplications on arelational DBMSplatform, and to providesome knowledge of the base technologies which are deployed in their implementation.
Course contents
Enterprise Information Systemsand 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 andnesting), views.SQL forapplications.
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 ofphysical organization (B+tree indexes, join methods, optimization).
Design of Information Systems.
Analysis of enterprise organization, requirements collection.The conceptual design of data: theEntity-Relationship model and the data schemata. The flow and operation schemata: Data-Flow Diagrams andWorkflows. 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 toSQL, 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 (throughoverhead projectoror 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 writtentest is passed if it receives a 18/30 score on a total score of 33/30. Once the writtentest is passed, the student has totake a final talk where the written test is discussed and the projectis 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