Database Systems - topics covered (academic year 2007/2008)

Problems given in the exams will address the following topics.

  • Elements of data base design methodology
    • Normalization
    • Elements of relational database theory
  • The structure of a Data Base Management System (DBMS)
  • Transaction management
    • The concept of transaction
    • Concurrency management
  • Crash management
    • Classification of failures dei guasti
    • Recovery
  • Physical structures for data bases
    • File organizations for data base management
    • Principles of physical database design
  • Query processing
    • Evaluation of relational algebra operators