Information Systems and Data AnalyticsModule description #40002 / Version 3
- 6 CP
- Portfolio examination
- Graded
- Summer semester
- German
This module description is not valid in the current semester (Winter semester 2026/27).
Current version (v14)
| Module / Version | #40002 / #3 |
|---|---|
| Validity | SS 2015 – SS 2015 |
| Available language(s) | German |
| Credit points | 6 |
| Person responsible for the module | Markl, Volker |
| Grading | Graded |
| Exam format | Portfolio examination |
| Language(s) of instruction | German |
Affiliation
| Faculty | Fakultät IV |
|---|---|
| Institute | Institut für Softwaretechnik und Theoretische Informatik |
| Academic chair | 34351500 FG Datenbanksysteme und Informationsmanagement (DIMA) |
Contact
| Office | FR 7-1 |
|---|---|
| Contact person | Borusan, Alexander |
| E-mail address | sekr@dima.tu-berlin.de |
| Website | https://www.tu.berlin/dima |
Learning outcomes
The participants of this class collect fundamental knowledge about information management using relational database concepts and database management systems from the viewpoint of database users and application developers.
First of all, they know how to construct good information models, using adequate concepts and methodology. These models are used to design and implement good relational schemata, in order to run complex queries efficiently. Finally the students will have knowledge about the fundamental architecture, prpoperties and task of database management systems and their advantages for consistent and efficient data storage.
First of all, they know how to construct good information models, using adequate concepts and methodology. These models are used to design and implement good relational schemata, in order to run complex queries efficiently. Finally the students will have knowledge about the fundamental architecture, prpoperties and task of database management systems and their advantages for consistent and efficient data storage.
Content
After a basic introduction into the client server architecture of database systems, the conceptual modeling and design of the intended database content using the Entity/Relationship model and its extensions (EER, UML) will be studied in detail. The next step is the translation of these models into relational schemata, including all steps of normalization.
Relational algebra and the classical query language SQL is the next learning step, followed by database programming in different settings.
The ACID properties for database transactions and their realization concludes this part of the lecture, followed by an introduction of query optimization.
Relational algebra and the classical query language SQL is the next learning step, followed by database programming in different settings.
The ACID properties for database transactions and their realization concludes this part of the lecture, followed by an introduction of query optimization.
Module components
Compulsory area
The following courses are mandatory for this module:
Workload and credit points
Informationssysteme und Datenanalyse (Lecture)
| Workload description | Multiplier | Hours | Total |
|---|---|---|---|
| Präsenzzeit | 15 | 2 h | 30 h |
| Vor-/Nachbereitung | 15 | 4 h | 60 h |
| 90 h | |||
Informationssysteme und Datenanalyse (Exercise)
| Workload description | Multiplier | Hours | Total |
|---|---|---|---|
| Präsenzzeit | 15 | 2 h | 30 h |
| Vor-/Nachbereitung | 15 | 4 h | 60 h |
| 90 h | |||
The workload of the module adds up to 180 hours. The module therefore comprises 6 credit points.
Description of teaching and learning methods
Vorlesung zur Stoffvermittlung mit begleitenden wöchentlichen Übungen (Tutorien) zur interaktiven Vertiefung und praktischen Einübung. Übungsaufgaben sowohl zum vertieften selbständigen Erarbeiten der theoretischen Anteile auch als auch zur praktische Übung mit einem DBMS.
Requirements for participation and examination
Desirable prerequisites for participation in the courses:
This module has no desirable prerequisites for the courses.
Mandatory requirements for the module examination registration:
This module has no examination requirements.
Completion of the module
| Grading | Graded |
|---|---|
| Exam format | Portfolio examination |
| Language | German |
Test elements
| Name | Points/Weight | Category | Duration/Extent |
|---|---|---|---|
| Hausaufgaben/Übungsblätter | 30 | ||
| Schriftliches Testat | 70 |
Exam description
Insgesamt können 100 Portfoliopunkte erreicht werden:
1. Bearbeitung der gestellten Übungsblätter (3 Übungsblätter mit je 10 Portfoliopunkten als Hausaufgabe in Kleingruppen, Anteil: 30 Portfoliopunkte)
2. Schriftliche Prüfung (Testat, Anteil: 70 Portfoliopunkte)
Die Gesamtnote gemäß § 47 (2) AllgStuPO wird nach dem Notenschlüssel 2 der Fakultät IV ermittelt.
1. Bearbeitung der gestellten Übungsblätter (3 Übungsblätter mit je 10 Portfoliopunkten als Hausaufgabe in Kleingruppen, Anteil: 30 Portfoliopunkte)
2. Schriftliche Prüfung (Testat, Anteil: 70 Portfoliopunkte)
Die Gesamtnote gemäß § 47 (2) AllgStuPO wird nach dem Notenschlüssel 2 der Fakultät IV ermittelt.
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: Summer semester.
Maximum number of participants
This module is not limited to a number of students.
Registration procedures
Die Einteilung der Tutorien erfolgt über MOSES in der ersten Vorlesungswoche. Die Prüfungsanmeldung erfolgt über QISPOS. Die An- und Abmeldefristen werden in der Vorlesung bekannt gegeben. Die Lehrmaterialien werden über ISIS bereitgestellt.
Recommended reading, lecture notes
Lecture notes
unavailable
Electronic lecture notes
unavailable
Recommended literature
- Elmasri und Navathe: "Fundamentals of Database Systems", Benjamin Cummings, bzw. Deutsche Ubersetzung: “Grundlagen von Datenbanksystemen,“ Pearson, 2002
- Garcia-Molina, Ullman, Widom: “Database Systems: The Complete Book,” Prentice Hall, 2000
- Kemper, Eickler: “Datenbanksysteme – Eine Einführung,” Oldenburg, 5. Auflage 2004
- Özsu und P. Valduriez: "Principles of Distributed Database Systems", Prentice Hall, 1999
Assigned programs
This module is not used in any program.
Miscellaneous
Not specified