CS 460 Database Technology (FSS 2019)

Important: This is an archived page for a past course. The most recent course Web page is found here.

Course Description

The course provides an introduction to relational database systems. The course will cover the following topics:

Principles of data storage
Database query languages (SQL)
Relational modeling
Keys and normal forms
Hash and index structures
Transactions and concurrency

Lecturers

Dates and Times

Lecture: Wednesday, 12.00 – 13.30, Room B6 A1.04
Exercise: Wednesday, 13.45 – 15.15, Room B6 A1.04

Exam Review

The exam review for the first exam from FSS2019 will take place on: Monday, 19 August, 8am, in room C1.01 (building B6, 26).
The exam review for the second exam from FSS2019 will take place on: Thursday, 19 September, 10am, in room C1.01 (building B6, 26).

Administrative Details
No formal registration (Portal2 or ILIAS) is required, but you are invited to join the ILIAS group.
Material and Literature
Slides
13.02.: Organization (PDF, 647 kB), Introduction (PDF, 2 MB)
20.02.: SQL Part 1 (PDF, 2 MB)
27.02.: SQL Part 2 (PDF, 2 MB)
06.3.: Entity Relationship Models (PDF, 3 MB)
13.03. Normal Forms (PDF, 1020 kB)
20.03. Indexing and Hashing (PDF, 3 MB)
27.03. Database Architectures (PDF, 3 MB)
03.04. Query Processing (PDF, 1 MB)
10.04. Query Optimization (PDF, 1 MB)
08.05. Transactions and Concurrency (PDF, 1 MB)
15.05. Recovery (PDF, 964 kB)
22.05. Applications (PDF, 904 kB)
Exercises
13.2.: Introduction (PDF, 129 kB) , schema, data
20.02.:SQL_1 (PDF, 226 kB) , employee_db
27.02.:SQL_2 (PDF, 98 kB), insurance_db
06.03.: Entity Relationship Models (PDF, 101 kB) , Umlet File
13.03.: Normal Forms (PDF, 107 kB)
20.03.: Indexing Hashing (PDF, 113 kB)
27.03. Database Architectures (PDF, 260 kB)
03.04. Query Processing (PDF, 183 kB)
10.04. Query Optimization (PDF, 140 kB), Easter Break (PDF, 81 kB)
08.05. Transaction and Concurrency (PDF, 118 kB)
15.05. Recovery (PDF, 117 kB)
Exercise solutions and additional materials will be made available in the corresponding ILIAS group.
The course will be based on the book Database System Concepts by Silberschatz et al.

Date	Topic
13.2.	Introduction
20.2.	SQL Part 1
27.2.	SQL Part 2
6.3.	ER Models
13.3.	Normal Forms
20.3.	Index and Hashing
27.3.	DB Architectures
3.4.	Query Processing
10.4.	Query Optimization
15.4.	Easter Break
22.4.	Easter Break
1.5.	Holiday
8.5.	Transactions and Concurrency
15.5.	Recovery
22.5.	Application Development