Hide menu

TDDD12 Database Technology

Lectures


Lecture 1: Introduction (Jose)

Edition 5: Chapter 1-2
Edition 6: Chapter 1-2

Slides pdf, ppt

Lecture 2: Relational databases and SQL (Jose)

Edition 5: Chapter 5 and 8
Edition 6: Chapter 3-5
Check also MySQL Reference Manual 6.0

Slides pdf, ppt

Lecture 3: EER modeling (Jose)

Edition 5: Chapter 3-4
Edition 6: Chapter 7-8

Slides pdf, ppt

Example to practice.

Lecture 4: Mapping of EER diagrams to relations (Jose)

Edition 5: Chapter 7
Edition 6: Chapter 9

Slides pdf, ppt

Lecture 5: Functional dependencies and normalization (Jose)

Edition 5: Chapter 10
Edition 6: Chapter 15 and 16.1

Slides pdf, ppt

Example to practice I and II.

Teaching session 1: Normalization (lab 3)

Slides: pdf, ppt

Lecture 6: Triggers and stored procedures. Data structures for databases I (Jose)

Procedures

MySQL Reference Manual 6.0 (Chapter 18)

Slides pdf, ppt

Data structures

Edition 5: Chapter 13
Edition 6: Chapter 17

Slides pdf, ppt

Lecture 7: Data structures for databases II. Muddy cards evaluation (Jose)

Edition 5: Chapter 14
Edition 6: Chapter 18

Slides pdf, ppt

Example to practice I and II.

Lecture 8: Transactions and concurrency control (Jose)

Edition 5: Chapter 17-18
Edition 6: Chapter 21-22

Slides pdf, ppt

Example to practice.

Teaching session 2: Project EER diagram (lab 4a)

OBS! Compulsory attendance of some member of the lab group.

Lecture 9: Recovery of databases (Jose)

Edition 5: Chapter 19
Edition 6: Chapter 23

Slides pdf, ppt

Example to practice.

Page responsible: Jose M. Peña
Last updated: 2014-04-17