- Docente: Alessandra Lumini
- Credits: 6
- SSD: ING-INF/05
- Language: English
- 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)
-
from Sep 20, 2023 to Dec 15, 2023
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
Readings/Bibliography
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