Data Management (academic year 2011/2012)
For whom is this course. This 6 credits course is for the students of the Master in Computer Engineering (School of Engineering) of the Sapienza Università di Roma. The course can also be attended by the students of the Laurea Magistrale in Ingegneria Informatica of the Sapienza Università di Roma, but they have to take into account that the language for both the course and the exam is English. The lectures will be held in the first semester (September 2011 - December 2011).
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 related to the theory and the design of relational database systems are covered, including concurrency control, recovery, file and index organizations, query processing.
Important notice. Only those students who are enrolled in the Master in Computer Engineering, or who attended the lectures of the Data Management course during the first semester can give the exam of Data Management. In particular students who book for the exam of Gestione dei Dati cannot take the exam of Data Management in the same academic year, and, conversely, students who book for the exam of Data Management cannot take the exam of Gestione dei Dati in the same academic year.
- News
- November 14, 2012 The exam of Data Management which was not held last Saturday will be held on Friday, November 16, 2012, in classroom B2 in via Ariosto 25.
- Lecture material
- M. Lenzerini, Lecture notes, Available in this site
- R. Ramakrishnan, J. Gehrke. Database Management Systems. McGraw-Hill, 2004
- Lectures
- When: Wednesday [15:45am -- 17:15am], Thursday [08:30am - 11:45am], from September 26, 2011 to December 20, 2011
- Where: via Ariosto 25, Roma, classroom B2
- Schedule
- Lecture notes
- Exercises
- 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 texts of past exams, and also at the grades of exams of previous academic years
- Schedule of final exams:
- First written exam: January 31, 2012
- Second written exam: February 24, 2012
- Special exam session: April 28, 2012
- Third written exam: June 20, 2012
- Fourth written exam: July 16, 2012
- Fifth written exam: September 24, 2012
- Second special exam session: November 13, 2012, at 3:45pm, classroom 33, via Eudossiana 18
- To book for the exam: Please, follow the on-line booking procedure.
- Information on past editions 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