Databases and WEB (2019/2020)



Course code
4S00012
Credits
6
Coordinator
Roberto Posenato
Academic sector
INF/01 - INFORMATICS
Language of instruction
Italian
Teaching is organised as follows:
Activity Credits Period Academic staff Timetable
Teoria 3 II semestre Roberto Posenato

Go to lesson schedule

Laboratorio 3 II semestre Roberto Posenato

Go to lesson schedule

Learning outcomes

------------------------
Theory unit
------------------------
The course aims to provide the necessary skills to:
(i) understand how computer network work
(ii) understand the internal architecture of systems for the management of relational databases
(iii) the use of a system for the management of relational databases in order to create, manage and query databases;
(iv) the development of applications that interact with relational databases.

At the end of the course the student must demonstrate:
(i) to know how systems for relational data management work, the SQL language fundamentals, and the fundamental mechanisms to develop applications that interact with a database;
(ii) to query and efficiently use the data managed by a system,
(iii) to apply the acquired knowledge to design and implement an application that interacts with a database,
(iv) to know how to develop the skills necessary to continue the studies independently in the field of data management systems and software solutions development.

------------------------
Lab unit
------------------------
The aim of this module is to provide the student with the necessary concepts and methods for working with a database management system and connect to it from external programs. To attend the course in a productive way, students have to be confident with object-oriented programming.

Syllabus

------------------------
Theory unit
------------------------
Computer networks (fundamentals).
The internal architecture of a database management system:
- sequential data structures and indexes (B-trees and hashing)
- transactions.
Semistructured data models: XML for bioinformatics.

Teaching methods
-------------------
Lecturing. Didactical material (slides) and further exercise texts are available on the eLearning platform. The teacher is available for individual meeting in office hours.

------------------------
Lab unit
------------------------
- Introduction to the relational database management system (RDBMS) PostgreSQL.
- Introduction to the use of SQL in PostgreSQL.
- Query Optimization.
- Introduction to the transaction.
- Database access from applications written in Java/Python.

Teaching methods
-------------------
Lecturing and practicing in a computer laboratory. Didactical material (slides) and further exercise texts are available on the eLearning platform. The teacher is available for individual meeting in office hours.

Assessment methods and criteria

The exam is composed of two parts: theory and laboratory.

To pass the exam, the student must show that:
- they are able to describe the concepts in a clear and exhaustive way without digressions
- they are able to apply the acquired knowledge to solve application scenarios described by means of exercises, questions and projects.

Module of Theory
----------------------------------------------------------------
For this module the exam consists of a written test with a duration of 1 hour containing: some questions and exercises on the theory topics.

Module of Laboratorio
---------------------------------
The examination consists of a written test containing 5 exercises based on the module program.
A student who obtains less than 13/30 in a written exam, will also have to take an oral examination once it has passed the written exam obtaining 18/30 at least. The final grade will be the average of two grades.

The grade in this module is worth 1/2 of the grade in the course examination.

A selection of previous exam tests is published at http://profs.scienze.univr.it/~posenato/courses/labBD/raccoltaTemiEsameLaboratorioBasiDatiDal2016.pdf

Reference books
Activity Author Title Publisher Year ISBN Note
Teoria Paolo Atzeni, Stefano Ceri, Piero Fraternali, Stefano Paraboschi, Riccardo Torlone Basi di dati (Edizione 5) McGraw Hill 2018 9788838694455
Teoria Docente del corso Dispense del docente  
Teoria Andrew S. Tanenbaum, David J. Wetherall Reti di calcolatori (Edizione 5) Pearson 2018
Laboratorio Docente del corso Dispense del docente  
Laboratorio Autori Vari Manuale di Postgresql (https://www.postgresql.org/docs/) Postgresql