Swedish web site
TDDD12 Database Technology
Lectures
We recommend that, before each lecture, you read the corresponding book chapters (see below).
Fö. 1: Introduction and EER modeling (Jose)
Edition 5: Chapter 1-4
Edition 6: Chapter 1-2 och 7
Fö. 2: Relational databases and SQL (Fang)
Edition 5: Chapter 5 och 8,
Edition 6: Chapter 3, 4 och 6
Check also MySQL Reference Manual 6.0
Fö. 3: Translation of EER model to relational model (Jose)
Edition 5: Chapter 7
Edition 6: Chapter 8
Slides pdf
Fö. 4: Functional dependencies and normalization (Jose)
Edition 5: Chapter 10
Edition 6: Chapter 14
Slides pdf
Excercise to practice 1 and 2.
Le. 1: Normalization (lab 3)
Fö. 5: Datastructures for databases, triggers and stored procedures (Fang)
Edition 5: Chapter 13
Edition 6: Kap 16, Kap 5
Slides index pdf
Slides triggers and stored procedures pdf
Le. 2: Project EER diagram (lab 4a)
Note that atendance of some member of the group is compulsory, in case you need to answer questions about yout diagram.
Fö. 6: Datastructures for databases, cont. Muddy cards evaluation (Fang)
Edition 5: Chapter 14
Edition 6: Chapter 17
Check also MySQL Reference Manual 6.0 (Chapter 18)
Slides pdf
Fö. 7: Transactions and concurrency control (Fang)
Edition 5: Chapter 17-18
Edition 6: Chapter 20-21
Slides pdf
Fö. 8: Database recovery (Jose)
Edition 5: Chapter 19
Edition 6: Chapter 22
Slides pdf
Fö. 9: Summary of the course, research and connections to other courses (Jose)
Page responsible: Jose M. Peña
Last updated: 2013-04-03
