TDDD46 Database Technology
Lectures
This page contains lecture material and reading guides for all the lectures. The reading guides refer to the textbook for the course (Elmasri, R. and Navathe, S. B. Fundamentals of Database Systems, Addison Wesley). The slides made available here may change until the day before the lecture.
Topic 1: Introduction
Edition 5: Chapters 1, 2
Edition 6: Chapters 1, 2
Edition 7: Chapters 1, 2
Slides, Slides for print-out (6 slides per page)
Topic 2: Relational databases
Edition 5: Chapter 5
Edition 6: Chapter 3
Edition 7: Chapter 5
Slides, Slides for print-out (6 slides per page)
Topic 3: SQL
Edition 5: Chapter 8
Edition 6: Chapters 4, 5
Edition 7: Chapters 6, 7
Check also MySQL 5.5 Reference Manual (chapter 13)
Slides, Slides for print-out (6 slides per page)
Topic 4: EER modeling
Edition 5: Chapters 3, 4
Edition 6: Chapters 7, 8
Edition 7: Chapters 3, 4
Slides, Slides for print-out (6 slides per page)
Topic 5: Mapping of EER diagrams to relations
Edition 5: Chapter 7
Edition 6: Chapter 9
Edition 7: Chapter 9
Slides, Slides for print-out (6 slides per page)
Topic 6: Functional dependencies and normalization
Edition 5: Chapter 10
Edition 6: Chapters 15 and 16.1
Edition 7: Chapters 14 and 15 (except for 14.6-14.7 and 15.4-15.6)
Slides, Slides for print-out (6 slides per page)
Topic 7: Stored procedures and triggers
MySQL Reference Manual 5.5 (chapters 13 and 20)
Slides, Slides for print-out (6 slides per page)
Teaching session 1: Normalization (Lab 3)
Slides, Slides for print-out (6 slides per page)
Teaching session 2: DB design for project (Lab assignment 4a)
Attendance mandatory!Topic 8: Data Structures for Databases
Edition 5: Chapter 13, 14
Edition 6: Chapter 17, 18
Edition 7: Chapter 16, 17
Slides, Slides for print-out (6 slides per page)
Topic 9: Introduction to Transaction Processing
Edition 5: Chapters 17
Edition 6: Chapters 21
Edition 7: Chapters 20
Slides, Slides for print-out (6 slides per page)
Topic 10: Transactions and Concurrency Control
Edition 5: Chapters 17, 18
Edition 6: Chapters 21, 22
Edition 7: Chapters 20, 21
Slides, Slides for print-out (6 slides per page)
Topic 11: Recovery of Databases
Edition 5: Chapter 19
Edition 6: Chapter 23
Edition 7: Chapter 22
Slides, Slides for print-out (6 slides per page)
Topic 12: Query Processing and Optimization
Edition 5: Chapters 6 and 15
Edition 6: Chapters 6 and 19
Edition 7: Chapters 18, 19
Slides, Slides for print-out (6 slides per page)
Page responsible: Olaf Hartig
Last updated: 2016-10-05