Introduction to Database SystemsModule description #40864 / Version 1
- 6 CP
- Written exam
- Graded
- Winter and summer semester
- English
This module description is not valid in the current semester (Winter semester 2026/27).
| Module / Version | #40864 / #1 |
|---|---|
| Validity | WS 2017/18 – WS 2017/18 |
| Available language(s) | English |
| Credit points | 6 |
| Person responsible for the module | Peroz, Nazir Ahmad |
| Grading | Graded |
| Exam format | Written exam |
| Language(s) of instruction | English |
Affiliation
| Faculty | Fakultät IV |
|---|---|
| Institute | Institut für Softwaretechnik und Theoretische Informatik |
| Academic chair | 34351900 FG Modelle und Theorie Verteilter Systeme (MTV) |
Contact
| Office | FH 5-2 |
|---|---|
| Contact person | Mailänder, Marius |
| E-mail address | peroz@tu-berlin.de |
| Website | Not 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.
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:
Workload and credit points
Introduction to Database Systems (Lecture)
| Workload description | Multiplier | Hours | Total |
|---|---|---|---|
| Präsenzzeit | 15 | 2 h | 30 h |
| Vor-/Nachbereitung | 15 | 2 h | 30 h |
| 60 h | |||
Introduction to Database Systems (Exercise)
| Workload description | Multiplier | Hours | Total |
|---|---|---|---|
| Präsenzzeit | 15 | 2 h | 30 h |
| Vor-/Nachbereitung | 15 | 6 h | 90 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.
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.
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
| Grading | Graded |
|---|---|
| Exam format | Written exam |
| Language | English |
| Duration/Extent | 90 |
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