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.
  • Preliminary notions (file)
  • The relational model (file)
  • Relational algebra (file)
  • SQL queries (file)
  • Data Definition and Modification in SQL (file)
  • Relational Algebra - Exercises (file)
  • SQL queries - Exercises (file)
  • Conceptual design (file)
  • Logical design (file)
  • Conceptual design -Exercises (file)
  • Logical design -Exercises (file)
  • Exam Simulation (file)

Additional material

  • SQL code for creating the Exercise DB (file)
  • Data Protection (file)