General Informations
- SSD: ING-INF/05
- ECTS: 8
- Official information sheet of the course
- Professor: Lia Morra
- Teaching Assistants: Francesco Manigrasso, Pietro Basci, Andrea Sordello, Alberto Verna
Announcements
- Announcements are posted on the Teaching Portal (Portale della Didattica)
- All discussions about the course can be opened on Piazza.
Timetable
| Type | Day of the week | Time | Classroom |
| Lecture | Monday | 13:00-16:00 | Room R2 |
| Lecture | Wednesday | 16:00-19:00 | Room R2 |
| Lab | Friday | 10:00-11:30 | Laib1 |
| Lab | Friday | 13:00-14:30 | Laib1 |
Material
- Introduction to the course (pdf)
- Introduction to databases (pdf, pdf6x)
- Relational data model (pdf, pdf6x)
- Database design
- Relational algebra (pdf, pdf6x)
- SQL language
- SQL for applications
- Trigger
- Trigger (pdf)
Classroom exercises
DesignER tool presentation: Link to presentation
| Topic | Text | Solution |
| Relational model | Relational model exercises | Relational model exercises commented |
| ER model | Entity relationship exercises | Entity relationship exercises solution (pdf) Entity relationship exercises solutions (Designer) ER restructuring and translation (pdf) |
| Conceptual design | Exercises part I Exercises part II | ex5 Babyparking |
| Relational algebra | Algebra part 1 Algebra part 2 | |
| SQL | ||
| Triggers |
Lab practice
Groups are divided by the surname initials.
| Student Group | Day of the week | Time | Classroom |
| Team 1: A-B | Friday | 10:00-11:30 | LAIB1 |
| Team 2: C-K | Friday | 10:00-11:30 | LAIB1 |
| Team 3: L-R | Friday | 13:00-14:30 | LAIB1 |
| Team 4: S-Z | Friday | 13:00-14:30 | LAIB1 |
| Lab dates | Topic | Material | Solution |
| 20/03/2026 (A-K) 20/03/2026 (L-Z) | ER and logical design | DesignER tool available at https://designerdb.io/ Lab exercises (text) | Solution (pdf) |
| 10/04/2026 (A-K) 10/04/2026 (L-Z) | Algebra | ||
| 24/04/2026 (A-K) 24/04/2026 (L-Z) | SQL I | Oracle Apex (online version) available at https://apex.oracle.com/ | |
| 08/05/2026 (A-K) 08/05/2026 (L-Z) | SQL II | ||
| 15/05/2026 (A-K) 15/05/2026 (L-Z) | Triggers | ||
| 29/05/2026 (A-K) 29/05/2026 (L-Z) | Web applications Streamlit I | ||
| 05/06/2026 (A-K) 05/06/2026 (L-Z) | Web applications Streamlit II |
Homeworks
- Homeworks will be published on the Moodle platform
Past Exams
- Past exams will be made available on Moodle