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 | |
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, draft solution (new – 2024-04-23) Exercises on SQL Language: select, join, group by, having (new – 2024-04-22) Exercises on SQL Language: in, not in (new – 2024-04-23) |
Data warehouse design |
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 (new – 2024-04-23) 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 (new – 2024-04-29) Scripts for database creation |
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.
Subject | Text | Delivery date | How to deliver | Points |
Database design | Exercise text | Friday, May 10, 2024 | The homework is to be done individually. Upload of the Homework solution is to be delivered on the Moodle platform. The platform will be available from Monday, April 29, 2024 | 0.5 |