DATABASE SYSTEMS - PART 2

The course is one of the basic activities of the BSc in Computer Science and complements the contents of the first module to provide a complete overview of databases from the point of view of the database administrator and software programmer.

The student will learn:
- the key results of the theory of normalization
- how to administer a relational database
- how to write applications interfacing with a database
- basics of non-relational data models (NoSQL)

Imperative programming and basics of object-oriented programming. Knowledge of the SQL language.

- Database normalization
- SQL for the administration of databases
- Development of applications interacting with a database
- Basics of non-relational data models

A. Albano, G. Ghelli, R. Orsini. Fondamenti di Basi di Dati. Zanichelli, 2005. (http://www.fondamentidibasididati.it/ )
M. Grinberg - Flask Web Development: Developing Web Applications with Python, 2018
H. Garcia-Molina, J. Ullman, J. Widom - Database Systems: The Complete Book, 2008

Verification of learning is carried out together with the other module of the course and takes place through a written test, the realization of a project and an oral test. The written test lasts 3 hours and consists of 5 exercises which aim to verify:

For Module 1:
1) the ability to design the conceptual schema of a database and the acquisition of the methodology to transform the conceptual schema into a relational schema,
2) the ability to query SQL.

For Module 2:
3) knowledge of the notions and algorithms related to the theory of normalization,
4) the ability to adequately administer a database through the definition of triggers, procedures and appropriate security practices,
5) the ability to write application code that interfaces with a database and to represent knowledge through non-relational models.

The written test can be replaced by passing two intermediate tests (the first during the winter session and the second in conjunction with the first session of the summer session). The first intermediate test verifies the skills 1) and 2) while the second intermediate test evaluates the knowledge 3), 4) and 5). The intermediate tests are considered passed if both have achieved a score greater than or equal to 17. Those who do not pass one of the two intermediate tests will have to face the entire written test in one of the subsequent sessions. During the written test the use of books, notes, electronic media is not allowed.

Frontal lectures and exercises.

Italian

written and oral