96793 - INFORMATION SYSTEMS AND DATABASE MANAGEMENT

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

- Advanced Excel database functions
- 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 recordings of the lessons are available on virtuale.unibo.it

Teaching methods

Mixed mode: Frontal and online lectures

Assessment methods

The final exam consists of two parts:

Part 1:
Practical test in the computer room.

Part 2:

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