Program of lectures and exercises Geo874

Timetable, scripts, assignments and solutions

(1) Introduction to DB Systems 19.09.2025

Motivation, comparison of DBMS and file-based data management, "DB in a nutshell", relational database, Pros- and Cons- of DB, big DB players

(2) SQL: the Structured Query language 26.09.2025

SQL concepts, SQL data types, SQL-commands (Select, Insert, Update, Delete, ...), views.

Lecture notes
Lab 2: SQL samples (sql text file format) with userdemo data. Play with these.
Exercise 2 - Task
Exercise 2 - Solution (sql)

(3) Complex SQL Queries & Intro to Database design 03.10.2025

Complex SQL Queries, permission, transaction, Phases of DB-design, requirement analysis, Entity-Relationship diagram (entity and attribute)

(4) Conceptual data modelling (ER Model) 10.10.2025

ER diagram cont. (relationship and constraints, relationship attributes, weak entity types, partial key, ...), build complete ER diagram

(5) Logical and physical DB-design 17.10.2025

Intro logical DB design (concepts, DB schema integrity, ...), table design concepts, integrity constraints, mapping rules (ER diagram --> logical model), physical DB design

(6) Advanced topics: Distributed databases, NoSQL 24.10.2025

Advanced considerations in data management: distributed databases, transactions in distributed databases, non-relational data storage.

We have finished grading the SQL Assignment. If you want to have a look at your grade, and see anything you have done wrong, please check OLAT.
Lecture notes
A Research & Production Database in Action
Exercise 6 - Task
Exercise 6 - Solution
Individual Evaluation - Lecture & Lab & Excercise open 24.10.2025 - 31.10.2025

(7) Exam Friday 31.10.2025

Friday 31.10.2025 8:40-9:40 in Y25-H79, be there at 8:30! Please remember to take an ID with you!
No lab!

Contact