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 2017
- Offered
- 2019/20
- 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 contents of the course on Databases (with Lab) will be the following (cfr. the program of the course for more details):
(1) Introduction to databases and database management systems
(2) Relational databases: Model and Languages. Relational model. Relational Algebra and calculus. SQL
(3) Database Design. E-R model. Conceptual and logic Design. Normalization.
(4) Database technology (brief introduction): Transactions, concurrency and security concepts. - Reference texts
- Main text:
R.A.Elmasri e S.B.Navathe: Fundamentals of Database Systems, Pearson Addison-Wesley - 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.
- Teaching methods
- ace-to-face lessons (for the theoretical part) + practical training in lab.
- Learning verification modality
- Written exam (for the theoretical part) + lab. exam + oral examination.
- Extended program
- The program for the theoretical part of the course on Databases (with Lab) is developed in four parts:
Part 1: Introduction to databases and database management systems
Part 2: Relational databases: Model and Languages.
* Relational model
* Relational Algebra and calculus
* SQL
Part 3: Database Design
* Design techniques and models. The E-R model.
* Conceptual Design.
* Logical Design.
* Normalization.
Part 4: Database technology (brief introduction)
* transactions, concurrency and security concepts.
Briefly, 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.