10906 - Databases

Course Unit Page

Academic Year 2019/2020

Learning outcomes

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

Course contents

  • Databases
  • Relational data model
  • Relational algebra and calculus
  • SQL
  • Database design methodology
  • ER data model and quality verification.
  • Laboratory: Notions about the architecture of a DBMS, indexes, transactions and design examples

Readings/Bibliography

Paolo Atzeni, Stefano Ceri, Stefano Paraboschi, Riccardo Torlone, Basi di dati - 5/ed, 2018, ISBN: 9788838694455

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, with an optional group project, consisting of 4 sections:

  1. Multiple choice questions for the verification of general knowledge of the course subjects.
  2. Exercise requiring writing queries in relational algebra and SQL.
  3. Exercise requiring the design of an E.R. diagram starting from a requirements description.
  4. Exercise and/or open questions for the laboratory part of the course.

Instructions for the group project.

  • The project allows for reaching the maximum exam score.
  • The group must be composed of 3 people, in exceptional cases 2 or 4, and must have a name of students' choice.
  • Before actually working on the project, students are required to send an email to labdbsi@cs'NOSPAM'.unibo.it, with subject [GroupName]-PROPOSAL-[ProjectTitle] (for example "Marco and Friends-PROPOSAL-Trucking Company").
  • After getting confirmation, the group can carry on the design of the database, producing the related documentation and implementing a basic web interface to execute the project queries.
  • In the report it is required to provide the link to the website.
  • Design steps and related documentation must follow this example: Google Drive link
  • The project report must be delivered to labdbsi@cs'NOSPAM'.unibo.it at least 7 days before the exam date, otherwise it will not be considered in the exam evaluation.

Instructions for the exam.

  • In order to take part in an exam session, you must register on Almaesami 7 days before the exam date. Those who do not enrol in time will not be able to take the exam, and will have to wait for the next date.
  • There are six dates per academic year. The dates are published on Almaesami and may vary. It is advisable to check 24 hours before the exam to check that the date has not changed.
  • The scores will be made available on Almaesami. Anyone who wishes to refuse the score must communicate it strictly within 5 days from the date of publication. After this term, the scores of those who have not explicitly rejected them are considered accepted, and the instructor will later register them.

Teaching tools

Instructor's folder with slides and other material: Google Drive link

Office hours

See the website of Danilo Montesi