TDDE49 Databases and Information Security for Bioinformatics
Lectures
This page contains lecture material including reading guides for all the lectures. The reading guides refer to the textbook for the course (Elmasri and Navathe: Fundamentals of Database Systems, Addison Wesley).
Table of Content
- Topic 1: Introduction
- Topic 2: Information security concepts
- Topic 3: Relational databases
- Topic 4: Basic SQL
- Topic 5: EER modeling
- Topic 6: Mapping of EER diagrams to relations
- Topic 7: Advanced SQL
- Topic 8: Information security modeling
- Topic 9: Database security
Topic 1: Introduction
Material: lecture slides
Edition 5: Chapters 1, 2
Edition 6: Chapters 1, 2
Edition 7: Chapters 1, 2
Topic 2: Information security concepts
Material: lecture slides
Topic 3: Relational databases
Video lecture: video (92:07 mins); this video is accessible only to people at LiU; please watch this video before the corresponding lecture session and, while you do so, take notes on things that are unclear to you so that we can clarify them in the lecture session.
Slides: as presented in the video
Material of the lecture session: will be made available here after the lecture session
Edition 5: Chapter 5
Edition 6: Chapter 3
Edition 7: Chapter 5
Topic 4: Basic SQL
Video lecture for the first SQL-related lecture session: part 1 (43:32 mins) and part 2 (49:12 mins); these videos are accessible only to people at LiU
Slides: as presented in the videos
Material of the lecture session: will be made available here after the lecture session
Edition 5: Chapter 8
Edition 6: Chapters 4, 5
Edition 7: Chapters 6, 7
Check also MySQL 5.5 Reference Manual (chapter 13)
Topic 5: EER modeling
Video lecture: video (51:46 mins), slides
Material of the lecture session: will be made available here after the lecture session
Edition 5: Chapters 3, 4
Edition 6: Chapters 7, 8
Edition 7: Chapters 3, 4
Topic 6: Mapping of EER diagrams to relations
Video lecture: video part 1 (13:14 mins), video part 2 (28:47 mins), video part 3 (16:25 mins), slides
Material of the lecture session: slides with quizzes and exercises
Edition 5: Chapter 7
Edition 6: Chapter 9
Edition 7: Chapter 9
Topic 7: Advanced SQL
Video lecture for the second SQL-related lecture session: part 1 (43:29 mins) and part 2 (50:54 mins)
Slides: as presented in the videos (in particular, slides 25 and following)
Material of the lecture session: will be made available here after the lecture session
Edition 5: Chapter 8
Edition 6: Chapters 4, 5
Edition 7: Chapters 6, 7
Check also MySQL 5.5 Reference Manual (chapter 13)
Topic 8: Information security modeling
Material: lecture slides
Topic 9: Database security
Material: lecture slides
Edition 5: Chapter 23
Edition 6: Chapter 24
Edition 7: Chapter 30
Page responsible: Olaf Hartig
Last updated: 2025-09-02