DATABASE SYSTEMS - PART 2

Academic year
2020/2021 Syllabus of previous years
Official course title
BASI DI DATI - MOD.2
Course code
CT0006 (AF:320637 AR:172528)
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 a 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
Written test and project. The written test will verify the knowledge of the main topics of the course through questions and exercises. The project will involve the development of a web application interacting with a database and will be orally discussed with the teacher. It will be possible to pass the exam together with the first module by passing two intermediate tests.
Frontal lectures and exercises.
Italian
written and oral
Definitive programme.
Last update of the programme: 14/12/2020