General Information
- Professor: Silvia Chiusano
- Teaching Assistant: Alessandro Fiori
Teaching Material
| SUBJECT | MATERIAL |
| Course introduction | Course introduction |
| Introduction to databases | Introduction to databases |
| Relational model | Relational model |
| Relational database design | Conceptual design: E-R model Logical design: Traslation of ER schema into Relational model Restructuring ER schema Time management |
| SQL Language | SQL Language: select, join, aggregated operators, group by SQL Language: in, not in SQL Language: update commands SQL Language: table management |
| Business intelligence | Data warehouse introduction (slides) Data warehouse design (slides) ETL (slides) OLAP (slides) |
Exercises
Laboratory Material
Homework
General information on Homework. Homework delivery is optional. For each homework, students can obtain the corresponding points if the homework is delivered by the deadline. The final exam grade is defined by considering the evaluation of the written part, and, optionally, of the delivered homework. Points from homework are considered only if the grade of the written part is 18 or above. Homework texts are pisted on the Moodle platforma available on the Didactic portal.