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

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
  • Entity-Relation Model (pdf, pdf6x)
  • Time representation (pdf, pdf6x)
  • Logical design – Translation (pdf, pdf6x)
  • Conceptual design example (pdf, pdf6x)
  • Logical design example (pdf, pdf6x)
  • Normalization (pdf, pdf6x)
• Relational algebra (pdf, pdf6x)
• SQL Language
  • Fundamentals (pdf, pdf6x)
  • Nested queries (pdf, pdf6x)
  • Set operators (pdf, pdf6x)
  • Advanced queries (pdf, pdf6x)
  • Update commands (pdf, pdf6x)
  • Table management (pdf, pdf6x)
  • Advanced SQL (pdf, pdf6x)
• Trigger
  • Trigger design (pdf, pdf6x)
• SQL for applications
  • Web applications (pdf)
  • Streamlit (pdf)
  • Live coding (pdf)

---

Classroom exercises

Topic	Text	Solution
Relational model	Relational model exercises	Relational model exercises commented
ER model	Entity relationship exercises	Entity relationship exercises solution (pdf) ER restructuring and translation (pdf)
Conceptual design	Exercises part I Exercises part II	ex5 (babyparking) Draft solutions (pdf)
Relational algebra	Algebra part 1 Algebra part 2	Solution part 1 Solution part 2 Sample exercise with solution
SQL	SQL 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)
Triggers	Ranking 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 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

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

Lab date	Topic	Text	Software	Solution
21/03/2025	Database 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/2025	Relational algebra	Lab/homework: text	designQT: designQT-basic Introduction to the designQT tool available at https://youtu.be/eEN2QjIQvgQ
10/04/2025*	SQL Queries (part 1)	Lab: text – database	Software : ORACLE APEX. Oracle Apex (online version) available at https://apex.oracle.com/	Solution (pdf)
08/05/2025*	SQL Queries (part 2)	See text above	Software : ORACLE APEX. Oracle Apex (online version) available at https://apex.oracle.com/	See above
16/05/2025	Triggers in Oracle	Lab: text – database	Software : ORACLE APEX. Oracle Apex (online version) available at https://apex.oracle.com/	Solution (pdf)
23/05/2025	Web applications with Streamlit I	Lab: text – database	– Streamlit. Info at https://streamlit.io – MySQL/phpMyAdmin with XAMPP. Info at https://www.apachefriends.org	Solution
30/05/2025	Web applications with Streamlit II	Lab/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:
  • Using Oracle APEX online

---

Homeworks

See Moodle platform

---

Past Exams

Past exams will be made available on Moodle