96793 - INFORMATION SYSTEMS AND DATABASE MANAGEMENT

Course Unit Page

SDGs

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

Quality education

Academic Year 2021/2022

Learning outcomes

Aim of the course is to understand the concepts and learn the techniques to access data stored in database systems for analytical purposes. In particular, the student will understand the main concepts of relational and noSQL database systems and will learn how to effectively extract data from those systems in order to prepare them for subsequent application of statistical and machine learning techniques. The course will deal with both the query languages of databases and the interfaces with programmatic languages, such as R or Python. At the end of the course the student is able: - to understand the structure of a given database, either relational or noSql; - to access the data stored in a Database Management System either with the specific standard languages or with programmatic interfaces.

Course contents

- Introduction on Database and DBMS
- The Relational Model
- The Entity-Relationship Model
- Data Modeling
- SQL

Readings/Bibliography

Atzeni Paolo et al., Basi di dati, McGraw-Hill, Milano, 2018, ISBN 9788838694455

Ramakrishnan Raghu, Gehrke Johannes, Database Management Systems, 3. revised ed., Mc Graw Hill, Boston, 2003, ISBN 9780072465631

Slides, notes and the recording of the lessons are available on virtuale.unibo.it

Teaching methods

Mixed mode: Frontal and online lectures

Assessment methods

Option 1: oral assessment

Option 2: project (description on virtuale.unibo.it)

Depending on the sanitary provisions, the methods of assessment may vary.

Links to further information

https://virtuale.unibo.it/course/view.php?id=25746

Office hours

See the website of Alessandro Lubisco