Databases - 228518-M2

courses

ID:

228518-M2

Dettaglio:

SSD: Data Processing Systems Duration: 48 CFU: 6

Located in:

DALMINE

Url:

Course Details:

MANAGEMENT ENGINEERING - 22-R/GENERALE Year: 1

Year:

2025

Course Catalogue:

https://unibg.coursecatalogue.cineca.it/af/2025?co...

Date/time interval

Secondo Semestre (23/02/2026 - 06/06/2026)

Course Objectives

Module on Data Bases: introducing issues on data management in information systems, data design techniques and technologies for data management. Students will train the mind to analyze and design enterprise data and manage them through a DBMS.

Course Prerequisites

Module on Data bases: basic notions on computer programming (only suggested).

Teaching Methods

Module on Data Bases: lectures and practical exercises in the lab with PCs.

Assessment Methods

Module on Data Bases: written test and optional oral test.

Module on Data Bases: Conceptual design: Entity-Relationship model. Logic design: the relational data model. Techniques for representing conceptual schemas into the relational data model. Querying data: relational algebra. The S E L E C T statement in SQL: simple queries, selection, grouping and aggregate functions. Different types of join. Nested queries. Architectures of information systems on the web. Introducing data warehousing systems. Introduction to BlockChain technology.