Hide menu

TDDD37 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 two days before the lecture.

Lecture 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)

Lecture 2: Relational databases and SQL

Edition 5: Chapters 5 and 8
Edition 6: Chapters 3-5
Edition 7: Chapters 5-7
Check also MySQL 5.5 Reference Manual (chapter 13)

Slides,   Slides for print-out (6 slides per page)

Lecture 3: 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)

Lecture 4: 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)

Lecture 5: 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)

Lecture 6: 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: pdf

Lecture 7: Data Structures for Databases I

Edition 5: Chapter 13
Edition 6: Chapter 17
Edition 7: Chapter 16

Slides,   Slides for print-out (6 slides per page)

Lecture 8: Data Structures for Databases II, Introduction to Transaction Processing

Edition 5: Chapters 14, 17
Edition 6: Chapters 18, 21
Edition 7: Chapters 17, 20

Slides,   Slides for print-out (6 slides per page)

Lecture 9: Transactions and Concurrency Control

Edition 5: Chapters 17, 18
Edition 6: Chapters 21, 22
Edition 7: Chapters 20, 21

Teaching session 2: DB design for project (Lab assignment 4a)

Attendance mandatory!

Lecture 10: Recovery of Databases

Edition 5: Chapter 19
Edition 6: Chapter 23
Edition 7: Chapter 22

Lecture 11: Query Processing and Optimization

Edition 5: Chapters 6 and 15
Edition 6: Chapters 6 and 19
Edition 7: Chapters 18, 19


Page responsible: Olaf Hartig
Last updated: 2016-10-05