Database Systems (2017/2018)

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
04./05.10.
Introduction and Motivation
Database Design
Only one single lab on 04.10. in D103
Slides (Chapter 1)
Slides (Chapter 2)
Script for university DB schema
Script for university DB data
Script for dropping the schema
Classwork 1
Most Linux distributions come with a PostgreSQL package.
Postgres database
Relational algebra interpreter (Python)
Relational algebra interpreter (Java, old version)
Week 2
11./12.10.
Large ER Modeling Classwork
Relational Model
Afternoon session on 11.10. in C201 at 14:00
Joint session of both groups
Slides (Chapter 3) Classwork 2
ER-model (group 1)
ER-model (group 2)
ER-model (group 3)
Week 3
18./19.10.
Relational Model
SQL
Slides (Chapter 4) Classwork 3
Exercise 1
Solution 1
EER Model
Modeling Exercises
Solution for Modeling Exercises
Crow's foot notation
Week 4
25./26.10.
SQL Classwork 4
Exercise 2
Solution 2
Week 5
02.11.
SQL
Relational Design Theory
Slides (Chapter 5)
Week 6
08./09.11.
Relational Design Theory Classwork 5
Exercise 3
Solution 3
Normalization Tool
Another Normalization Tool (jar file)
Week 7
15./16.11.
Data Storage Slides (Chapter 6) Classwork 6
Classwork 7
Exercise 4
Solution 4
Week 8
22./23.11.
Query Processing Slides (Chapter 7) Classwork 8
Exercise 5
Exercise 5 (PDF)
Solution 5
Week 9
29./30.11.
Query Processing
Transaction Management
Recovery
Slides (Chapter 8)
Slides (Chapter 9)
Classwork 9
Exercise 6
Solution 6
Week 10
06./07.12.
Multi-user Synchronization Slides (Chapter 10) Classwork 10
Exercise 7
Solution 7
Week 11
13./14.12.
Multi-user Synchronization Classwork 11
Exercise 8
Solution 8
Week 12
20./21.12.
No lectures
No labs
Week 13
10./11.01.
Multi-user Synchronization
Wrapping Up
Application Architectures/JDBC
Mock Exam
Slides (Chapter 11)
JDBC
Database application architectures
Exercise 9
Solution 9
JDBC example code
serializable snapshot isolation
Week 14
17.01.
Revision Lecture
Will take place in E422

http://www.inf.unibz.it/dis/teaching/DBS/
Last Updated: Thu Jan 11 11:18:50 CET 2018