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 (updated 2024-03-06) |
| Relational database design | Conceptual design: E-R model, DesignerFiles, ER restructuring and translation Logical design: Traslation of ER schema into Relational model Restructuring ER schema |
| SQL Language | SQL Language: select, join, aggregated operators, group by (new – 2024-04-12) SQL Language: in, not in (new – 2024-04-23) SQL Language: update commands (new – 2024-04-30) SQL Language: table management (new – 2024-04-30) |
| 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, draft solution) – STEP Programme (exercise text, draft solution ER diagram) |
| SQL Language | Exercises on SQL Language: select, join: text, draft solution Exercises on SQL Language: select, join, group by, having: text, draft solution Exercises on SQL Language: in, not in: text, draft solution |
| Data warehouse design | Italian household appliance company (exercise text, draft solution) Property rent adverts (exercise text, draft solution) (new – 2024-06-10) Italian wines (exercise text, draft solution) (new – 2024-06-10) |
Laboratory Material
| Practice | Subject | Material |
| 15/04/2024 | Database design | Exercise text and draft solution |
| 22/04/2024 | SQL Language (join, group by) | Software : ORACLE APEX. Oracle Apex (online version) available at https://apex.oracle.com/ Using Oracle APEX online (guide) Exercise text, Query output, Query solution Scripts for database creation |
| 29/04/2024 | SQL Language (join, group by, in, not in)) | Software : ORACLE APEX. Oracle Apex (online version) available at https://apex.oracle.com/ Using Oracle APEX online (guide) Exercise text, Query output, Query solution Scripts for database creation |
| 06/05/2024 | Google Looker Studio | Practice #1: Text (pdf) Practice #2: Text (pdf, Video tutorials available on youtube channel) |
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.