DATABASES AND SECURITY | Università degli studi di Bergamo

DATABASES AND SECURITY

Attività formativa monodisciplinare
Codice dell'attività formativa: 
148011

Scheda dell'insegnamento

Per studenti immatricolati al 1° anno a.a.: 
2020/2021
Insegnamento (nome in italiano): 
DATABASES AND SECURITY
Insegnamento (nome in inglese): 
Databases and security
Tipo di attività formativa: 
Attività formativa Affine/Integrativa
Tipo di insegnamento: 
Obbligatoria
Settore disciplinare: 
SISTEMI DI ELABORAZIONE DELLE INFORMAZIONI (ING-INF/05)
Anno di corso: 
2
Anno accademico di offerta: 
2021/2022
Crediti: 
6
Responsabile della didattica: 

Altre informazioni sull'insegnamento

Modalità di erogazione: 
Didattica Convenzionale
Lingua: 
Inglese
Ciclo: 
Primo Semestre
Obbligo di frequenza: 
No
Ore di attività frontale: 
48
Ore di studio individuale: 
90
Ambito: 
Attività formative affini o integrative
Prerequisites

Basic notions on computer programming (only suggested).

Educational goals

Introduction to data management problems in information systems and database design methodologies. Introduction to the EU rules governing the management of personal data.
The student will acquire the reasoning schemes to analyze and design a corporate database and use data management systems (DBMS). The student will also acquire the basic notions regarding the EU rules for the protection of personal data.

Course content

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 SQL language: simple queries, with selection, grouping, and aggregate functions, different types of Join, and nested queries. Introduction to the EU General Data Protection Regulation (GDPR).

Teaching methods

Teaching will take place through lectures, but giving importance to confrontation and direct dialogue with the students, who, during the lessons, will be able to formulate questions and proposals for further study. Great importance will also be given to the exercises that will be carried out in the classroom by both the teacher and the students themselves. In some cases the exercises will be carried out using personal computers.

Assessment and Evaluation

The exam consists of a written test. The test contains four types of exercises:
(1) a conceptual modeling exercise;
(2) a logical design exercise;
(3) an exercise about queries in both relational algebra and SQL;
(4) theoretical questions on the course content.

Further information

If it will be necessary to hold the course remotely or in a mixed way, the syllabus could be modified in order to make the course and the exams suitable for these teaching methods.