10906 - Databases

Academic Year 2017/2018

  • Teaching Mode: Traditional lectures
  • Campus: Bologna
  • Corso: First cycle degree programme (L) in Computer Science (cod. 8009)

Learning outcomes

At the end of the course the student: - knows the relational data model ed the basic constructors of SQL; - can design and develop a database; - is capable of processing a project to implement and information system.

Course contents

Databases, relational data model, relational algebra and calculus, SQL, database design methology, ER data model and quality verification. Notions about the architecture of a DMBS, indexes and transactions.

Readings/Bibliography

Paolo Atzeni, Stefano Ceri, Stefano Paraboschi, Riccardo Torlone, Basi di dati - Modelli e linguaggi di interrogazione 4/ed, 2013, ISBN:  9788838668005

Teaching methods

During the course lessons we will discuss several issues related to the design, development and querying of a database system.

Assessment methods

Written exam.

Teaching tools

Instructur slides.

Office hours

See the website of Danilo Montesi