Moses - Introduction to Database Systems

Display language

To modulepage Generate PDF

Diese Modulbeschreibung gilt nicht im aktuellen Semester.

Die Modulbeschreibung gilt nur für den Zeitraum SoSe 2020 - SoSe 2022.

Module / Version:
#40864 / #2

Validity:
SoSe 2020 - SoSe 2022

Default display language:
English

Module title:
Introduction to Database Systems

Credits:
6

Responsible person:
Peroz, Nazir Ahmad

Grading:
benotet

Type of exam:
Schriftliche Prüfung

Zugehörigkeit

Faculty:
Fakultät IV

Institute:
Institut für Softwaretechnik und Theoretische Informatik

Area of expertise:
34351900 FG Modelle und Theorie Verteilter Systeme (MTV)

Prüfungsausschuss:
No information

Kontakt

Office:
FH 5-2

Contact person:
Mailänder, Marius

E-mail address:
peroz@tu-berlin.de

Website:
No information

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

Pflichtgruppe:

All Courses are mandatory.

Course Name	Type	Number	Cycle	Language	SWS	VZ
Introduction to Database Systems	VL		k.A.	No information	2
Introduction to Database Systems	UE		k.A.	No information	2

Workload and Credit Points

Introduction to Database Systems (VL):

Workload description	Multiplier	Hours	Total
Präsenzzeit	15.0	2.0h	30.0h
Vor-/Nachbereitung	15.0	2.0h	30.0h
			60.0h(~2 LP)

Introduction to Database Systems (UE):

Workload description	Multiplier	Hours	Total
Präsenzzeit	15.0	2.0h	30.0h
Vor-/Nachbereitung	15.0	6.0h	90.0h
			120.0h(~4 LP)

The Workload of the module sums up to 180.0 Hours. Therefore the module contains 6 Credits.

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 test application:

1. Requirement

Modul40873 [IT Systems in Developing Countries I] registered

Module completion

Grading

graded

Type of exam

Written exam

Language

English

Duration/Extent

Duration of the Module

The following number of semesters is estimated for taking and completing the module:
1 Semester.

This module may be commenced in the following semesters:
Winter- und Sommersemester.

Maximum Number of Participants

The maximum capacity of students is 25.

Registration Procedures

Online-registration via QISPOS is required.

Recommended literature
No recommended literature given

Assigned Degree Programs

This module is not used in any degree program.

Miscellaneous

No information

Introduction to Database Systems