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
- Evaluation of relational algebra operators