DATA BASES - 21061-MOD2

courses
ID:
21061-MOD2
Dettaglio:
SSD: Data Processing Systems Duration: 40 CFU: 5
Located in:
DALMINE
Url:
COMPUTER SCIENCE AND ENGINEERING - 21-270/PERCORSO COMUNE Year: 2
Approval Status:
Draft
Year:
2025
Course Catalogue:
https://unibg.coursecatalogue.cineca.it/af/2025?co...

Overview

Date/time interval

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

Syllabus

Course Objectives

The course illustrates the fundamental concepts on the use and design of relational databases.

Course Prerequisites

There are no formal requirements. It is expected that students have already acquired all the basic computer science concepts.

Teaching Methods

Lectures presenting the concepts and the resolution of exercises, lab sessions.

Assessment Methods

Written exam. It is offered the opportunity to develop a small project.

Contents

INTRODUCTION TO THE COURSE
The information system in a company
Characteristics of DBMSs and the concept of transaction
Users, tools and modules of a DBMS
RELATIONAL THEORY
The relational data model, its definition (informal and formal) and basic concepts
Relational algebra: unary and binary operations
Queries in relational algebra and their optimization
Relational calculus: definition, equivalence between relational algebra and relational calculus
Datalog: definition, recursive queries, specification of integrity constraints,
Relations between the expressive power of the formal languages
LANGUAGES FOR DATABASES
Introduction to SQL: SQL standards, SQL domains, constraints and simple definition of tables
SQL as a DDL: referential integrity, schema definition and modification, relational catalogs
Simple SQL queries, queries with sorting and grouping, complex SQL Queries
Update commands and views in SQL
Advanced aspects: generic indexes and integrity constraints, access control, views
SQL Programming: SQL functions, Embedded SQL, ODBC / ADO, JDBC, SQL procedures
DESIGN OF DATABASES
Stages of the design
The abstractions in the design of data
The Entity-Relationship model: definition, associations, identifiers and hierarchies, properties
The design cycle: strategies, quality of a conceptual design
Logical design: logical phases of the project, the elimination of hierarchies, management of identifiers, attribute management, association management, normalization (outline)
Physical design (outline)

Online Resources

More information

https://cs.unibg.it/bd.html

Degrees

Degrees

COMPUTER SCIENCE AND ENGINEERING - 21-270 
Bachelor's Degree
3 years
No Results Found

People

Other

Main module

C.I. OPERATING SYSTEMS + DATABASES