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 | 13:00-16:00 | Room R2 |
| Lecture | Wednesday | 16:00-17:30 | Room R2 |
| Lecture | Friday | 11:30-13:00 | Room R2 |
| Lab | Tuesday | 13:00-14:30 | LabInf |
| Lab | Friday | 10:00-11:30 | Laib2B |
| Lab | Friday | 17:30-19:00 | Laib1 |
Material
- Introduction to the course (pdf)
- Introduction to databases (pdf, pdf6x)
- Relational data model (pdf, pdf6x) [Last update:10/03/2024]
- Database design
- Entity-Relation Model (pdf, pdf6x) [Last update: 13/03/2024]
- Time representation (pdf, pdf6x) [Last update: 04/04/2024]
- Logical design – Translation (pdf, pdf6x) [Last update: 19/03/2024]
- Conceptual design example (pdf, pdf6x)
- Logical design example (pdf, pdf6x)
- Normalization (pdf, pdf6x) [Last update: 04/04/2024]
- Relational algebra (pdf, pdf6x)
- SQL language
- SQL for applications
- Trigger
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) [Updated 4/4/2024] 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 | Solution part 1 Solution part 2 |
| SQL | SQL exercises part I SQL exercises part II | SQL exercises part I (solutions) |
Lab practice
Groups are divided by the surname initials.
| Student Group | Day of the week | Time | Classroom |
| Team A: A-F | Tuesday | 13:00-14:30 | LabInf |
| Team B: G-N | Friday | 10:00-11:30 | LAIB2B |
| Team B: O-Z | Friday | 17:30-19:00 | LAIB1 |
| Lab dates | Topic | Material | Solution |
| 09/04/2024 (A-F) 12/04/2024 (G-Z) | Database design (E-R and logical design) | Introduction to the DesignER tool available at https://designerdb.io/ Lab exercises (text) | Solution (pdf) |
| 30/04/2024 (A-F) 03/05/2024 (G-Z) | SQL Basics | Software : ORACLE APEX. Oracle Apex (online version) available at https://apex.oracle.com/ | |
| 07/05/2024 (A-F) 10/05/2024 (G-Z) | Advanced SQL I | ||
| 14/05/2024 (A-F) 17/05/2024 (G-Z) | Advanced SQL II | ||
| 21/05/2024 (A-F) 24/05/2024 (G-Z) | Triggers | ||
| 28/05/2024 (A-F) 31/05/2024 (G-Z) | Web applications with Streamlit I | ||
| 04/06/2024 (A-F) 07/06/2024 (G-Z) | Web applications with Streamlit II |
- 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