Photo credit: Anna Logue

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:

The exam review for the first exam from FSS2019 will take place on: Monday, August 19th, 8am, in room C1.01 (building B6, 26).
The exam review for the second exam from FSS2019 will take place on: Thursday, September 19th, 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, Introduction

20.02.: SQL Part 1

27.02.: SQL Part 2

06.3.: Entity Relationship Models

13.03. Normal Forms

20.03. Indexing and Hashing

27.03. Database Architectures

03.04. Query Processing

10.04. Query Optimization

08.05. Transactions and Concurrency

15.05. Recovery

22.05. Applications

Exercises

13.2.: Introduction , schema, data

20.02.:SQL_1 , employee_db

27.02.:SQL_2, insurance_db

06.03.: Entity Relationship Models , Umlet File

13.03.: Normal Forms

20.03.: Indexing Hashing

27.03. Database Architectures

03.04. Query Processing

10.04. Query Optimization, Easter Break

08.05. Transaction and Concurrency

15.05. Recovery

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