Unit DATABASES AND INFORMATION SYSTEMS WITH LAB

Course
Informatics
Study-unit Code
55083809
Curriculum
In all curricula
Teacher
Raffaella Gentilini
Teachers
  • Raffaella Gentilini
Hours
  • 78 ore - Raffaella Gentilini
CFU
9
Course Regulation
Coorte 2021
Offered
2023/24
Learning activities
Caratterizzante
Area
Discipline informatiche
Academic discipline
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.
Condividi su