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) |
| 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 | Software : ORACLE APEX. Oracle Apex (online version) available at https://apex.oracle.com/ Exercise text, Query output, Query solution (new – 2024-04-23) Scripts for database creation |
| 29/04/2024 | SQL Language | Software : ORACLE APEX. Oracle Apex (online version) available at https://apex.oracle.com/ (new – 2024-04-23) Exercise text |
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 |