General Informations
- SSD: ING-INF/05
- ECTS: 8
- Official information sheet of the course
- Professor: Lia Morra
- Assistant lecturers: Davide Calandra, Francesco Manigrasso
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 | 11:30 – 14:30 | Room R1 |
| Lecture | Wednesday | 16:00-19:00 | Room 2P |
| Lab | Friday | 10:00-11:30 | Laib1 |
| Lab | Friday | 17:30-19:00 | Laib1 |
Material
- Introduction to the course (pdf)
- Introduction to databases (pdf, pdf6x)
- Relational data model (pdf, pdf6x)
- Database design
Classroom exercises
| Topic | Text | Solution |
| Relational model | Relational model exercises | Relational model exercises commented |
| ER model | Entity relationship exercises |
DesignER tool presentation: Link to presentation
Lab practice
Groups are divided by the surname initials.
| Student Group | Day of the week | Time | Classroom |
| Team TBD | Friday | 10:00-11:30 | LAIB1 |
| Team TBD | Friday | 17:30-19:00 | LAIB1 |
- Installation guides, to work on the lab practices you can use oracle directly on your PC or online through Oracle APEX. We suggest you to use the online option, following the guide below:
Homeworks
See Moodle platform
Past Exams
Past exams will be made available on Moodle