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, 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, 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