90107 - BASI DI DATI (9 CFU)

Academic Year 2023/2024

  • 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 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 - 6/ed, 2023, ISBN: 9788838656545

Teaching methods

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

Considering the the type of activity and teaching methods adopted, the course attendance requires that all students follow Module 1 and 2 of security training in study places, through e-learning.

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 bd@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 by email to address above 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 

Links to further information

http://smartdata.cs.unibo.it/internships-thesis

Office hours

See the website of Danilo Montesi

SDGs

Quality education Gender equality Decent work and economic growth Industry, innovation and infrastructure

This teaching activity contributes to the achievement of the Sustainable Development Goals of the UN 2030 Agenda.