Information Systems and Data AnalysisModule description #40002 / Version 11
- 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 / #11 |
|---|---|
| Validity | Summer semester 2023 – Winter semester 2023/24 |
| 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
Information systems are fundamental in business and industrial applications. Flight bookings, online shopping, large enterprise resource planning and production control systems are just a few examples. Driving modern economy and science today are individuals with competences in efficient data management and deep data analysis, whose contributions lead to new insights and facilitate decision-making. Upon completion of this course, students will have: (i) mastered basic concepts in information management and relational database management systems (RDBMS), (ii) learned how to develop information models, and (iii) grasped how to formulate queries in relational algebra and express these in SQL. They will be able to describe a data warehouse, compare it to transaction systems, and decide which requirements are essential for a given application profile. Furthermore, they will learn about data analytics using classification & clustering algorithms and apply them to a database using SQL.
Content
1. Architecture of Information Systems
2. Relational Data Model
3. Relational Algebra
4. Query Language SQL
5. Transaction systems
6. Data Warehousing
7. Data Base Management vs Data Streams Management
8. Introduction to Data Science
9. Algorithms for Data Analytics: Classification & Clustering algorithms
2. Relational Data Model
3. Relational Algebra
4. Query Language SQL
5. Transaction systems
6. Data Warehousing
7. Data Base Management vs Data Streams Management
8. Introduction to Data Science
9. Algorithms for Data Analytics: Classification & Clustering algorithms
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 |
|---|---|---|---|
| lecture | 15 | 2 h | 30 h |
| lecture preparation | 15 | 1 h | 15 h |
| 45 h | |||
Informationssysteme und Datenanalyse (Exercise)
| Workload description | Multiplier | Hours | Total |
|---|---|---|---|
| tutorial | 15 | 2 h | 30 h |
| lecture preparation | 15 | 2 h | 30 h |
| 60 h | |||
Course-independent workload
| Workload description | Multiplier | Hours | Total |
|---|---|---|---|
| Continuous assessments | 3 | 15 h | 45 h |
| Test preparation | 1 | 30 h | 30 h |
| 75 h | |||
The workload of the module adds up to 180 hours. The module therefore comprises 6 credit points.
Description of teaching and learning methods
Lectures to convey the material with accompanying weekly exercises (tutorials) for interactive consolidation and practical practice. Exercises both for in-depth independent work on the theoretical parts and for practical exercises with a DBMS.
Requirements for participation and examination
Desirable prerequisites for participation in the courses:
keine Angabe
Mandatory requirements for the module examination registration:
This module has no examination requirements.
Completion of the module
| Grading | Graded |
|---|---|
| Exam format | Portfolio examination |
| Type of portfolio examination | 100 points in total |
| Language | German |
Test elements
| Name | Points/Weight | Category | Duration/Extent |
|---|---|---|---|
| Continuous assessment: Database queries | 25 | practical | 25 h |
| Continuous assessment: Database creation | 15 | practical | 10 h |
| Continuous assessment: Programming exercise | 10 | practical | 10 h |
| Written test | 50 | written | 60 Min. |
Exam description
Grading key:
1,0: >= 90,5
1,3: >= 86,0
1,7: >= 81,5
2,0: >= 77,0
2,3: >= 72,5
2,7: >= 68,0
3,0: >= 63,5
3,3: >= 59,0
3,7: >= 54,5
4,0: >= 50,0
5,0: < 50,0
1,0: >= 90,5
1,3: >= 86,0
1,7: >= 81,5
2,0: >= 77,0
2,3: >= 72,5
2,7: >= 68,0
3,0: >= 63,5
3,3: >= 59,0
3,7: >= 54,5
4,0: >= 50,0
5,0: < 50,0
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
The allocation of tutorials is done via MOSES before the start of the lecture -- please note the announcement. Registration for exams is done via the official registration system of the TU Berlin.
The registration and deregistration deadlines will be announced in the lecture. The teaching materials will be provided via ISIS.
Please be sure to follow all regulations of your course of study!
The registration and deregistration deadlines will be announced in the lecture. The teaching materials will be provided via ISIS.
Please be sure to follow all regulations of your course of study!
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
- Guttag, John V: "Introduction to computation and programming using Python," MIT Press, 2013
- Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer Widom: Database Systems - The Complete Book, Pearson Prentice Hall, 2009.
- 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 version is used in the following programs:
| Program / program version | Semester(s) | Curriculum component |
|---|---|---|
| Economics StuPO 2022 | SS 2023 | Compulsory Elective Area › Markets and Technology |
| WS 2023/24 | Compulsory Elective Area › Markets and Technology | |
| Economics StuPo 2018 | SS 2023 | Compulsory Elective Modules › Markets and Technology |
| WS 2023/24 | Compulsory Elective Modules › Markets and Technology | |
| Industrial Engineering and Management Industrial Engineering and Management (B. Sc.) - StuPO 2015 | SS 2023 | Integrationsbereich › Integrationsbereich (Wahlpflicht) |
| WS 2023/24 | Integrationsbereich › Mathematik und Quantitative Methoden (Wahlpflicht) |
Miscellaneous
Not specified