- Docente: Dario Maio
- Credits: 12
- SSD: ING-INF/05
- Language: Italian
- Moduli: Dario Maio (Modulo 1) Alessandra Lumini (Modulo 2)
- Teaching Mode: Traditional lectures (Modulo 1) Traditional lectures (Modulo 2)
- Campus: Cesena
- Corso: First cycle degree programme (L) in Computer Science and Information Technology (cod. 8013)
Learning outcomes
Fundamentals of the relational database systems technology; methodologies and tools for database design and implementation.
Course contents
· Data Models : an outline of hierarchical and network data models. The relational model; the relational algebra: basic and derived operators, implementation of the operators. Normal forms.
· The SQL language : the main statements..
· Notes on structural characteristics, parameters and reliability of external storage devices .
· RDBMS Architecture : Query Optimizer, Transaction Manager, Scheduler, Recovery Manager, Cache Manager, Storage Manager, Access Methods.
· Relational database design: the Entity-Relationship model, introduction to requirement analysis and to conceptual database design. Logical database design. Normalization techniques. Outline of physical database design.
· .NET C# database applications : overview of data access modalities and fundamentals of Linq Language.
Readings/Bibliography
lecture slides are available at http://bias.csr.unibo.it/maio/
· D. Maio, S. Rizzi, A. Franco. Esercizi di Progettazione di Basi di Dati. Esculapio, 2005.
· P. Atzeni, S. Ceri, S. Paraboschi, R. Torlone. Basi di Dati: modelli e linguaggi di interrogazione, McGraw-Hill Italia, 2006.
· P. Atzeni, S. Ceri, S. Paraboschi, R. Torlone. Basi di Dati. Architetture e linee di evoluzione; McGraw-Hill Italia, 2003.
· P. Ciaccia, D. Maio. Lezioni di Basi di Dati. Esculapio, 2002.
Teaching methods
The lectures will focus on database design and implementation. The course is integrated with guided class and laboratory exercises, where the theoretical aspects are put into practice.
Assessment methods
The examination consists of three parts:
1. A laboratory project concerning either the design and implementation of a database application or the development of a software module related to one of the lecture topics. The accomplishment of the project is necessary qualification for the examination.
2. Written test with exercises and questions about the course topics. Examples are available at the course web site.
3. An optional oral examination (upon successful completion of the written test) consisting of questions related to the course program.
Teaching tools
Several RDBMSs are available in the laboratory (SQL Server, Access, Oracle,…); SQL Server is used for the laboratory exercises. Moreover DB-Main is adopted to design E/R schemes during the exercises. Microsoft Visual Studio and C# are adopted for development of DB applications.
Links to further information
http://bias.csr.unibo.it/maio/courses/bd/bd.htm
Office hours
See the website of Dario Maio
See the website of Alessandra Lumini