Database Systems (2016/2017)

BSc in Computer Science and Engineering

General Information

Mock Exam

Reading List

Further Reading (optional)

Assessment

Project

Time Table and Course Material

Date Topic Slides Exercises External links
Week 1
12./13.10.
Introduction and Motivation
Database Design
Only one exercise on 12.10. in D003
Slides (Chapter 1)
Slides (Chapter 2)
Script for university DB schema
Script for university DB data
Classwork 1
Postgres database
Relational algebra interpreter
Week 2
19./20.10.
Large ER Modeling Classwork
Relational Model
Afternoon session on 19.10. in A518 at 14:00
No (regular) exercises this week
Slides (Chapter 3) Classwork 2
ER-model (group 1)
ER-model (group 2)
ER-model (group 3)
Exercise 1
Solution 1
Week 3
26./27.10.
Relational Model
SQL
One afternoon session on 26.10. in A518 at 14:00
Slides (Chapter 4) Classwork 3
Week 4
02./03.11.
SQL
No exercises this week
Lecture on 02.11. in E422 at 14:00
Classwork 4
Exercise 2
Solution 2
Week 5
09./10.11.
Relational Design Theory Slides (Chapter 5) Classwork 5 Normalization Tool
Week 6
16./17.11.
Exercise sessions only
Lectures are replaced with exercises
Exercise 3
Solution 3
Week 7
23./24.11.
Relational Design Theory
Data Storage
Slides (Chapter 6) Classwork 6
Classwork 7
Exercise 4
Solution 4
Week 8
30.11./01.12.
Data Storage
Query Processing
Slides (Chapter 7) Classwork 8
Exercise 5
Solution 5
Week 9
07.12.
Query Processing
Transaction Management
Recovery
Slides (Chapter 8)
Slides (Chapter 9)
Classwork 9
Exercise 6
Solution 6
Week 10
14.12./15.12
Recovery
Multi-user Synchronization
Slides (Chapter 10) Classwork 10
Exercise 7
Week 11
21.12.
Multi-user Synchronization Classwork 11
Exercise 8
Solution 8
additional slides for normalization
Week 12
11./12.01.
Multi-user Synchronization
Wrapping Up
Revision lecture
Slides (Chapter 11) Exercise 9 serializable snapshot isolation

http://www.inf.unibz.it/dis/teaching/DBS/
Last Updated: Thu Jan 12 20:26:42 CET 2017