Skip to content
Technische Universität Berlin Deutsch
Course catalog and module transfer system

Introduction to Database SystemsModule description #40864 / Version 1

← Module page Deutsche Fassung
This module description is not valid in the current semester (Winter semester 2026/27).
Module / Version#40864 / #1
ValidityWS 2017/18 – WS 2017/18
Available language(s)English
Credit points6
Person responsible for the modulePeroz, Nazir Ahmad
GradingGraded
Exam formatWritten exam
Language(s) of instructionEnglish

Affiliation

FacultyFakultät IV
InstituteInstitut für Softwaretechnik und Theoretische Informatik
Academic chair34351900 FG Modelle und Theorie Verteilter Systeme (MTV)

Contact

OfficeFH 5-2
Contact personMailänder, Marius
E-mail addressperoz@tu-berlin.de
WebsiteNot specified

Learning outcomes

Successful participants of this course will have the theoretical background to understand the basics of database systems. This includes knowledge of the relational database design process, the client-view usage and the server-side workings of DBMS. They will also have a firm grasp of using this theoretical knowledge in the practical context of current database systems. Furthermore, the participants will get an overview about other relevant topics of the field.

Content

The course will cover the following topics:

Part 1: Theoretical Foundations
1. Introduction, the relational model (Algebra, Calculus)
2. Schema design (normal forms, normalization etc)
3. Modeling

Part 2: DBMS Implementation
1. Concurrency, Locking and Transactions
2. Recovery
3. File & Buffer Management
4. Indexing

Part 3: Advanced Topics
1. Distributed DBMS (Distributed Locking and Transactions)
2. NoSQL data models (graph, table, tuple etc)

Besides this, the exercises will deepen the understanding of the theoretical knowledge by providing concrete projects and exercises.

Module components

Compulsory area

The following courses are mandatory for this module:

CoursesTypeNumberFrequencyLanguageHours per weekCourse catalog
Introduction to Database SystemsLecture Irregular–2 ISIS
Introduction to Database SystemsExercise Irregular–2 ISIS

Workload and credit points

Introduction to Database Systems (Lecture)

Workload descriptionMultiplierHoursTotal
Präsenzzeit152 h30 h
Vor-/Nachbereitung152 h30 h
60 h

Introduction to Database Systems (Exercise)

Workload descriptionMultiplierHoursTotal
Präsenzzeit152 h30 h
Vor-/Nachbereitung156 h90 h
120 h

The workload of the module adds up to 180 hours. The module therefore comprises 6 credit points.

Description of teaching and learning methods

Lecture and practical exercises about selected topics .

The lecture introduces the theoretical concepts and gives practical examples. The exercises seek to apply this knowledge to practical problems. Weekly assignments are given, the results are discussed in the exercise.

Requirements for participation and examination

Desirable prerequisites for participation in the courses:

Only scholarship holders of the CS Master's Program for Afghan Lecturers are enabled to enroll.
Für diese Veranstaltung sind ausschließlich Stipendiaten des CS Masterprogramms für afghanische Dozenten zugelassen.

Mandatory requirements for the module examination registration:

The examination requirements could not be retrieved.

Completion of the module

GradingGraded
Exam formatWritten exam
LanguageEnglish
Duration/Extent90

Duration of the module

The following number of semesters is estimated for taking and completing the module: 1 semester(s).

This module can be started in the following semesters: Winter and summer semester.

Maximum number of participants

The maximum capacity of participants is 25.

Registration procedures

Online-registration via QISPOS is required.

Recommended reading, lecture notes

Lecture notes

unavailable

Electronic lecture notes

unavailable

Recommended literature

No recommended literature given

Assigned programs

This module is not used in any program.

Miscellaneous

Not specified