Academic Year 2022/2023

  • Teaching Mode: Traditional lectures
  • Campus: Forli
  • Corso: Second cycle degree programme (LM) in Economics and management (cod. 9203)

    Also valid for Campus of Cesena
    Second cycle degree programme (LM) in Digital Transformation Management (cod. 5815)

Course contents

- The relational model; the structure of the relational model, integrity constrints, Normal forms.

- The SQL language : Data definition and manipulation, Query databases

- Main components of a RDBMS: 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.

- Brief introduction to NoSQL Systems


Lecture slides are available at Unibo e-learning platform.

Further reading: 

P. Atzeni, S. Ceri, P. Fraternali, S. Paraboschi, R. Torlone. Database Systems: Concepts, Languages and Architectures, McGraw-Hill.

R. Elmasri , S. B. Navathe. Fundamentals of Database Systems. Pearson.


Teaching methods

The course is provided by means of slides displayed during lecture hours and it is integrated with guided class and laboratory exercises, where the theoretical aspects are put into practice.

Due to health emergency part of the lectures may be held online (Teams).

As concerns the teaching methods of this course unit, all students must attend Module 1, 2 on Health and Safety online


Assessment methods

In order to take part in an exam session, students must register on Almaesami.

The examination consists of three parts:

1. A laboratory project concerning either the design and documentation of a database application or the solution of some home assignments. The accomplishment of the project is necessary qualification for the examination.

2. Written test with exercises and questions about the course topics. During the written test it is not allowed to consult any kind of material.

3. An optional oral examination (upon successful completion of the written test) consisting of questions related to the course program.



Teaching tools

Classroom lessons will be held using slides.

Teaching materials (slides, code examples, exercises and solutions) are made avalaible to students through the Unibo e-learning platform.

Several RDBMSs are available in the laboratory (SQL Server, Access, Oracle, MySQL). MySQL is used for the laboratory exercises. Moreover some database design tools are available.


Office hours

See the website of Alessandra Lumini