Databases
A.Y. 2022/2023
Learning objectives
The aim of the course is to introduce the fundamental concepts concerning database theory by illustrating the main design and query techniques for relational databases.
Expected learning outcomes
At the end of the course, the student must be able to design, implement and query relational databases. Among the skills is the ability to solve a problem using various formalisms at different abstraction levels.
Lesson period: First semester
Assessment methods: Esame
Assessment result: voto verbalizzato in trentesimi
Single course
This course cannot be attended as a single course. Please check our list of single courses to find the ones available for enrolment.
Course syllabus and organization
Single session
Responsible
Lesson period
First semester
The teaching will be delivered synchronously on the zoom platform according to the timetable of the first semester.
Remote examinations, if necessary, will be carried out in oral form using the zoom platform.
The exam, in particular, will be aimed at:
- test the achievement of the objectives in terms of knowledge and understanding;
- test the ability to apply knowledge and understanding of the subject by discussing topics of the lectures and solving exercises.
Remote examinations, if necessary, will be carried out in oral form using the zoom platform.
The exam, in particular, will be aimed at:
- test the achievement of the objectives in terms of knowledge and understanding;
- test the ability to apply knowledge and understanding of the subject by discussing topics of the lectures and solving exercises.
Course syllabus
The course is devoted to the databases theory. The main relational database design and query techniques will be presented.
The main topics are:
- Introduction to DBMS systems. The relational data model and relational algebra. SQL - a relational database language. Data modeling using the entity-relationship approach. Functional dependencies and normalization for relational databases.
The main topics are:
- Introduction to DBMS systems. The relational data model and relational algebra. SQL - a relational database language. Data modeling using the entity-relationship approach. Functional dependencies and normalization for relational databases.
Prerequisites for admission
Knowledge of the main concepts and operators related to set theory and Boole algebra is recommended.
Teaching methods
Front lessons.
Teaching Resources
Web site:
http://pperlascabd.ariel.ctu.unimi.it/
References:
- B. Catania, E. Ferrari, G. Guerrini Sistemi di Gestione Dati - Concetti e architetture Città Studi Edizioni
- B. Carminati, A. Maddalena, M. Mesiti - Sistema di gestione dei dati - Esercizi - Città Studi Edizioni
Additional supplementary material is available on the teaching website.
http://pperlascabd.ariel.ctu.unimi.it/
References:
- B. Catania, E. Ferrari, G. Guerrini Sistemi di Gestione Dati - Concetti e architetture Città Studi Edizioni
- B. Carminati, A. Maddalena, M. Mesiti - Sistema di gestione dei dati - Esercizi - Città Studi Edizioni
Additional supplementary material is available on the teaching website.
Assessment methods and Criteria
The examination consists of a written test concerning the topics covered in the teaching typically organized in three application type exercises having content and similar difficulties to those faced in the exercises. The evaluation, expressed in thirtieths, takes into account the level of mastery of the topics, the clarity of presentation and the ability to analyze and solve a problem. Any additional information on the evaluation methods will be illustrated during the course. After the written test, students with a vote greater than or equal to 18 can request to take an oral test which, starting from the contents of the written test, can concern all the topics covered in the course. Take the oral test do not necessarily result in an improvement of the written test vote.
Professor(s)