| Course name |
Informatics |
|---|
| Study-unit Code |
55083809 |
|---|
| Curriculum |
Comune a tutti i curricula |
|---|
| Lecturer |
Raffaella Gentilini |
|---|
| Lecturers |
|
|---|
| Hours |
- 78 ore - Raffaella Gentilini
|
|---|
| CFU |
9 |
|---|
| Course Regulation |
Coorte 2023 |
|---|
| Supplied |
2025/26 |
|---|
| Supplied other course regulation |
|
|---|
| Learning activities |
Caratterizzante |
|---|
| Area |
Discipline informatiche |
|---|
| Sector |
INF/01 |
|---|
| Type of study-unit |
Obbligatorio (Required) |
|---|
| Type of learning activities |
Attività formativa monodisciplinare |
|---|
| Language of instruction |
Italian |
|---|
| Contents |
Briefly, the course will cover the following content: (1) Introduction to databases and database management systems (DBMS) (2) Relational databases: Model and Languages. Relational model. Relational Algebra and Relational Calculus. SQL language (3) Database Design. Entity Relation (ER) model. Conceptual and logic Design. Normalization. (4) Database technology: Transactions, concurrency and security concepts. |
|---|
| Reference texts |
Main text: R.A.Elmasri e S.B.Navathe: Fundamentals of Database Systems, Pearson Addison-Wesley, 7th edition, 2022 Others references: [UW02] --- J.Ullman e J.Widom. First Course in Database Systems. 2a edizione. Prentice Hall |
|---|
| Educational objectives |
Students will be introduced to the design and analysis of database systems.They will get a deeper understanding by implementing these concepts in a commercial database management system. |
|---|
| Prerequisites |
-- |
|---|
| Teaching methods |
face-to-face lessons (for the theoretical part) + practical training in lab. |
|---|
| Learning verification modality |
Written and oral examination. |
|---|
| Extended program |
The program for the theoretical part of the course is developed in four parts: Part 1: Introduction to databases and database management systems * historical development of databases and databases management systems Part 2: Relational databases: Model and Languages. * Relational model * Relational Algebra * Relational Calculus * SQL Language Part 3: Database Design * Design techniques and models. * Conceptual Design. * Entity-Relation (Er and Enhanced Entity-Relation (EER) model. * Logical Design: algorithms for mapping ER and EER models into relational models. * Physical Design: Indices * Normalization: functional dependences, first, second, third and Boyce-Code normal form.Normalization algorithms. Part 4: Database technology * transactions, concurrency and security concepts. Finally, the program for the lab. will cover the following topics: * The Postgres DBMS * SQL language: schema definition, constraints, queries, and views. Basic and advanced instructions. Usage of the DBMS PostGres for realizing a database. * SQL programming techniques. Trigger and active databases. Embedded SQL. JDBC. |
|---|
