10906 - Databases

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.
• Laboratory: Notions about the architecture of a DMBS, indexes and transactions.

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 verfication 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.

Istructions for the group project.

• The project allows to reach 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.
• It is required to provide in the report the link to the website.
• Design steps and related documentation must follow the following example: Google Drive link
• The project report must be delivered to labdbsi@cs'NOSPAM'.unibo.it at least 7 days from 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 before 7 days of the exam date. Those who do not enroll in time will not be able to take the exam, and will have to wait for the next date.
• There are six dates a 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 scoresof 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