Introduction To Databases
Courses

Introduction To Databases

General Informations

  • SSD: ING-INF/05
  • ECTS: 8
  • Official information sheet of the course
  • Professor: Lia Morra
  • Teaching Assistants: Francesco Manigrasso, Pietro Basci, Andrea Sordello, Alberto Verna

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-19:00Room R2
Lab Friday10:00-11:30Laib1
Lab Friday13:00-14:30Laib1

Material

  • Introduction to the course (pdf)
  • Introduction to databases (pdf, pdf6x)
  • Relational data model (pdf, pdf6x)
  • Database design

Classroom exercises

DesignER tool presentation: Link to presentation

TopicTextSolution
Relational modelRelational model exercises
ER model
Conceptual design
Relational algebra
SQL
Triggers

Lab practice

Groups are divided by the surname initials.

Student GroupDay of the weekTimeClassroom
Team 1: A-BFriday10:00-11:30LAIB1
Team 2: C-KFriday10:00-11:30LAIB1
Team 3: L-RFriday13:00-14:30LAIB1
Team 4: S-ZFriday13:00-14:30LAIB1

  • 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

  • Homeworks will be published on the Moodle platform

Past Exams

  • Past exams will be made available on Moodle