Introduction To Databases

Introduction To Databases

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

TypeDay of the weekTimeClassroom
LectureMonday13:00-16:00Room R2
LectureWednesday16:00-17:30Room R2
LectureFriday11:30-13:00Room R2
LabTuesday13:00-14:30LabInf
LabFriday10:00-11:30Laib2B
LabFriday17:30-19:00Laib1


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
    • Web applications (pdf)
    • Streamlit (pdf)
    • Live coding (pdf)
  • Trigger
    • Trigger (pdf, pdf6x) [Last update: 24/5/2024]

Classroom exercises

DesignER tool presentation: Link to presentation

TopicTextSolution
Relational modelRelational model exercisesRelational model exercises commented
ER modelEntity relationship exercisesEntity relationship exercises solution (pdf) [Updated 4/4/2024]
Entity relationship exercises solutions (Designer)
ER restructuring and translation (pdf)
Conceptual designExercises part I
Exercises part II
ex5 (babyparking)
Draft solutions (pdf) [Updated 19/5/2024]
Relational algebraAlgebra part 1
Algebra part 2
Solution part 1
Solution part 2
Sample exercise with solution
SQLSQL exercises part I
SQL exercises part II
SQL exercises part III
SQL exercises part I (solutions)
SQL exercises part II (partial solutions)
SQL exercises part III (partial solutions)
TriggersRanking exercise
Scholarship exercise
Event calendar exercise
Leave requests exercise
Ranking draft solution
Scholarship exercise
Event calendar draft solution
Leave requests draft solution


Lab practice

Groups are divided by the surname initials.

Student GroupDay of the weekTimeClassroom
Team A: A-FTuesday13:00-14:30LabInf
Team B: G-NFriday10:00-11:30LAIB2B
Team B: O-ZFriday17:30-19:00LAIB1

Lab datesTopicMaterialSolution
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 BasicsSoftware : ORACLE APEX. Oracle Apex (online version) available at https://apex.oracle.com/
Lab: textdatabase
solution
07/05/2024 (A-F)
10/05/2024 (G-Z)
Advanced SQL ILab: text databasesolution
14/05/2024 (A-F)
17/05/2024 (G-Z)
Advanced SQL IILab: text solution
21/05/2024 (A-F)
24/05/2024 (G-Z)
TriggersLab: textdatabasesolution
28/05/2024 (A-F)
31/05/2024 (G-Z)
Web applications with Streamlit ILab: textdatabase
04/06/2024 (A-F)
07/06/2024 (G-Z)
Web applications with Streamlit IILab: text database

  • 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