Time: Tuesday, 4. DS (13:00-14:30)
Location: APB/E001
Quantity: 2V/2Ü/0P
Language: English
Modules: DSE-14-M3

Exercises

Chapter Content Material
1 SQL pdf
h2-mondial.jar
2 Practical Exercise 1 – Introduction pdf
Material
Theoretical Background
3 ER models pdf
4 Relational Algebra pdf
5 Practical Exercise 1 – Recap pdf
6 Functional Dependencies pdf
7 Normal Forms, Outer Join, Semi Join pdf
8 Buffer Management, Recovery pdf
9 Trees pdf
10 Fragmentation, Views, Database Index pdf
11 Practical Exercise 2 – JOINs pdf

Material
12 Locking, MVCC pdf
12 Transactions pdf
13 Practical Exercise 2 – Recap pdf