You are here:

10906 - Databases

Academic Year 2022/2023

                
                        Docente:
                        Alessandra Lumini
                    
                        Credits:
                        6
                    
                        SSD:
                        ING-INF/05
                    
                        Language:
                        Italian
                    
                        Teaching Mode:
                        Traditional lectures
                        
                            Campus:
                            Cesena
                        
                            Corso:
                            First cycle degree programme (L) in
                            Computer Systems Technologies (cod. 5816)

                            Teaching resources on Virtuale
                        
                                    Course Timetable
                                
from Feb 20, 2023 to May 15, 2023

Learning outcomes

The student learns the fundamental principles of the relational data model and of the relational database management systems. In particular, the student will be able to understand the structure of a relational database, the integrity constraints on data and the SQL query language. Moreover, the student gains an introductory background in NoSQL architectures and non-relational data models.

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.

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