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
Classroom exercises
DesignER tool presentation: Link to presentation
| Topic | Text | Solution |
| Relational model | Relational model exercises | |
| ER model | Entity relationship exercises | |
| Conceptual design | Exercises part I Exercises part II | |
| Relational algebra | ||
| 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 |
- Introduction to the DesignER tool available at https://designerdb.io/
- 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
- Homeworks will be published on the Moodle platform
Past Exams
- Past exams will be made available on Moodle