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
- Relational algebra (pdf, pdf6x)
- SQL Language
Classroom 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 A: AA-KOM | Friday | 10:00-11:30 | LAIB1 |
| Team B: KOR-ZZ | Friday | 17:30-19:00 | LAIB1 |
| Lab date | Topic | Material | Solution |
| 21/03/2025 | Database design (E-R and logical design) | Introduction to the DesignER tool available at https://designerdb.io/ Lab exercises (text) | Solution (pdf) |
- 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