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
| SUBJECT | MATERIAL |
| Relational model | Exercises on relational model |
| Design of relational databases | Exercises con conceptual database design using ER model (exercise text) Exercises on conceptual and logical database design – AirQ company, Research organization, Forniture store (exercise text) – Beauty farm (exercise text) – STEP Programme (exercise text) |
| SQL Language | Exercises on SQL Language: select, join: text Exercises on SQL Language: select, join, group by, having: text Exercises on SQL Language: in, not in: text |
| Data warehouse design | Italian household appliance company (exercise text) Property rent adverts (exercise text) Italian wines (exercise text) |
Laboratory Material
| Practice | Subject | Material |
| 21/3/2024 | Database design | Exercise text |
| SQL Language (join, group by) | ||
| SQL Language (join, group by, in, not in)) | ||
| Google Looker Studio |
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.