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 (file)
  • Preliminary notions (file)
  • The relational model (file)
  • Relational algebra (file)
  • Relational algebra - exercises (file)
  • SQL queries (file new version)
  • Data Definition and Modification in SQL (file)
  • SQL queries - exercises 1 (file)
  • SQL queries - exercises 2 (file) - NEW -
  • Conceptual design (file)
  • Conceptual design - exercises new (file)
  • Logical design (file)
  • Ligical design - exercises new (file)
  • Data Protection (file)

Additional material

  • SQL code for creating the Exercise DB (file)