- 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 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. Simple and complkex queries. The MS-Access system. 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. Data modeling with UML.
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.
- R. ELMASRI, S. NAVATHE, Fundamentals of Database Systems, Addison-Wesley, third edition, 2000.
- M. GOLFARELLI, S. RIZZI, Data Warehouse (in Italian), McGraw-Hill, 2002.
- 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
Informal notes (in Italian) on the course topics are available on the Web or as photocopies.
Links to further information
http://www-db.deis.unibo.it/~fgrandi/didattica.html
Office hours
See the website of Fabio Grandi