Lecture material

Books

English version.
Paolo Atzeni, Stefano Ceri, Stefano Paraboschi and Riccardo Torlone. Database Systems - Concepts, Languages and Architectures
Note that the english version of the book is available for free download.

Italian version.
Paolo Atzeni, Stefano Ceri, Piero Fraternali, Stefano Paraboschi e Riccardo Torlone. Basi di dati - 5/ed

Lecture slides

The slides will be available during the lecture period.
  • Course introduction
  • Preliminary notions
  • The relational model
  • Relational algebra
  • Relational algebra - exercises
  • SQL queries
  • Data Definition and Modification in SQL
  • SQL queries - exercises
  • Conceptual design
  • Conceptual design - Exercises 1
  • Conceptual design - Exercises 2 (ITA)
  • Logical design
  • Ligical design - Exercises
  • Data Protection
  • Exam Simulation

Additional material

  • SQL code for creating the Exercise DB