Introduction To Databases
Courses

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		SQL exercises part I (solutions)
SQL exercises part II (draft solutions)
SQL exercises part III (draft solutions)
TriggersRanking exercise
Scholarship exercise
Event calendar exercise
Leave requests exercise		Ranking draft solution
Scholarship exercise
Event calendar draft solution
Leave requests draft solution

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: text – databaseSoftware : ORACLE APEX. Oracle Apex (online version) available at https://apex.oracle.com/Solution (pdf)
    08/05/2025*SQL Queries (part 2)See text aboveSoftware : ORACLE APEX. Oracle Apex (online version) available at https://apex.oracle.com/See above
    16/05/2025Triggers in OracleLab: text – databaseSoftware : ORACLE APEX. Oracle Apex (online version) available at https://apex.oracle.com/Solution (pdf)
    23/05/2025Web applications with Streamlit ILab: text – database– Streamlit. Info at https://streamlit.io
    – MySQL/phpMyAdmin with XAMPP. Info at https://www.apachefriends.org
    30/05/2025Web applications with Streamlit IILab/homework: text – database– Streamlit. Info at https://streamlit.io
    – MySQL/phpMyAdmin with XAMPP. Info at https://www.apachefriends.org

    • 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