Database Systems (academic year 2007/2008)



For whom is this course. This 5 credits course is for the students of the Master in Computer Engineering (School of Engineering) of the Sapienza Università di Roma.
Prerequisites. A good knowledge of the fundamentals of Programming Structures, Programming Languages, and Databases (SQL, relational data model, Entity-Relationship data model, conceptual and logical database design) is required.
Course goals. The course presents the basic concepts of database systems, emphasizing the relational model. Several major issues of relational database systems and theory are covered: data dependencies and their use in schema design, concurrency control, file organizations, query processing.


  • News
    • July 15, 2008: The next exam will be held on September 18, 2008, 2:30 PM.
  • Text and transparencies
    • M. Lenzerini, Lecture notes, Available in this site
    • R.Ramakrishnan, J. Gehrke. Database Management Systems. McGraw-Hill, 2004
  • Lectures
    • When: from January 14, 2008 to March 15, 2008, every Monday, Thursday and Friday, 15:45 pm - 17:15 pm
    • Where: Room A3, Dipartimento di informatica e sistemistica, via Ariosto 25, Roma
    • Schedule
    • Lecture notes
  • Exercises
    • Transparencies
  • Exam
    • Topics covered
    • Final exam: the final exam is constituted by a written exam, and a possible oral examinations. Students have 2 hours for completing the written exam
    • Past written exams: you can have a look at the problems proposed in past exams, both in Italian, and in English (in this case, grades are also included)
    • Schedule of final exams:
      • First written exam: March 28, 2008
      • Second written exam: April 17, 2008
      • Third written exam: July 9, 2008
      • Fourth written exam: September 18, 2008, 2:30 PM, Room 33, via Eudossiana 18
      • Fifth written exam: December 2008
    • To book for the final exam: Please, follow the on-line booking procedure
  • Information on past editions (in Italian) of this course
  • Office hours. Tuesday, 5:00 pm, at the Dipartimento di Informatica e Sistemistica "Antonio Ruberti", via Ariosto 25, Roma, second floor, room B203 (if available), or room B217 (otherwise) -- please, look at the last minute news for the next office hours