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
LectureMonday11:30 – 14:30Room R1
LectureWednesday16:00-19:00Room 2P
LabFriday10:00-11:30Laib1
LabFriday17:30-19:00Laib1


Material


Classroom exercises

TopicTextSolution
Relational modelRelational model exercisesRelational model exercises commented
ER modelEntity relationship exercisesEntity relationship exercises solution (pdf)
ER restructuring and translation (pdf)
Conceptual designExercises part I
Exercises part II
ex5 (babyparking)
Draft solutions (pdf)
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
TriggersRanking exercise
Scholarship exercise
Event calendar exercise
Leave requests exercise

DesignER tool presentation: Link to presentation


Lab practice

Groups are divided by the surname initials.

Student GroupDay of the weekTimeClassroom
Team A: AA-KOMFriday10:00-11:30LAIB1
Team B: KOR-ZZFriday17:30-19:00LAIB1

* Rescheduled laboratory sessions to be held in Room 1P (Team A: 08:30-10:00, Team B: 10:00-11:30)

    Lab dateTopicTextSoftwareSolution
    21/03/2025Database design (E-R and logical design)Lab exercises (text)designER: designER / designER-basic
    Introduction to the designER tool available at https://designerdb.io/
    Solution (pdf)
    [Update 08/04/2025]
    04/04/2025Relational algebraLab/homework: textdesignQT: designQT-basic
    Introduction to the designQT tool available at https://youtu.be/eEN2QjIQvgQ
    10/04/2025*SQL Queries (part 1)Lab: textdatabaseSoftware : ORACLE APEX. Oracle Apex (online version) available at https://apex.oracle.com/
    08/05/2025*SQL Queries (part 2)See text aboveSoftware : ORACLE APEX. Oracle Apex (online version) available at https://apex.oracle.com/
    16/05/2025Triggers
    23/05/2025Web applications with Streamlit I
    30/05/2025Web 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