DATABASE SYSTEMS - PART 2

Academic year
2023/2024 Syllabus of previous years
Official course title
BASI DI DATI - MOD.2
Course code
CT0006 (AF:401983 AR:218225)
Modality
On campus classes
ECTS credits
6 out of 12 of DATABASE SYSTEMS
Degree level
Bachelor's Degree Programme
Educational sector code
INF/01
Period
2nd Semester
Course year
2
Where
VENEZIA
Moodle
Go to Moodle page
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/ )
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
Definitive programme.
Last update of the programme: 14/06/2023