Fundamentals of Databases
Module IN0008
This module handbook serves to describe contents, learning outcome, methods and examination type as well as linking to current dates for courses and module examination in the respective sections.
Basic Information
IN0008 is a semester module in German language at Bachelor’s level which is offered in winter semester.
| Total workload | Contact hours | Credits (ECTS) |
|---|---|---|
| 180 h | 75 h | 6 CP |
Content, Learning Outcome and Preconditions
Content
SQL, data integrity, theory of relational database design, physical data organisation (storage structures, index structures), query processing, transaction management, main features of error handling (recovery, backup) and multi-user synchronisation, security aspects (authorization), XML data modeling (optional); in the exercise the content is practiced along concrete examples
Learning Outcome
Students are able to apply the essential concepts of relational database systems and can use and evaluate them systematically and in a qualified manner.
The students have the expertise to systematically use a database system starting from the conceptual design to the implementation design to the physical design. They are able to formulate even complex queries in SQL and have a basic understanding of logical and physical optimization based on relational algebra. Furthermore they know how to safe-guard a database application with respect to recovery, concurrency control and authorization.
The students have the expertise to systematically use a database system starting from the conceptual design to the implementation design to the physical design. They are able to formulate even complex queries in SQL and have a basic understanding of logical and physical optimization based on relational algebra. Furthermore they know how to safe-guard a database application with respect to recovery, concurrency control and authorization.
Preconditions
IN0015 Discrete Structures, IN0001 Introduction to Informatics 1
Courses, Learning and Teaching Methods and Literature
Courses and Schedule
WS 2022/3
WS 2021/2
WS 2020/1
WS 2019/20
WS 2018/9
WS 2017/8
WS 2016/7
WS 2015/6
WS 2014/5
WS 2013/4
WS 2012/3
| Type | SWS | Title | Lecturer(s) | Dates | Links |
|---|---|---|---|---|---|
| VO | 3 | Fundamentals of Databases (IN0008) | Jungmair, M. Kemper, A. Lehner, S. Sichert, M. Vogel, L. |
Wed, 10:00–13:00, Interims I 101 Wed, 10:00–13:00, MW 0001 |
eLearning documents |
| UE | 2 | Fundamentals of Databases, Exercise Session (IN0008) Groups 1-25 |
Jungmair, M.
Lehner, S.
Sichert, M.
Vogel, L.
Responsible/Coordination: Kemper, A. |
documents |
|
| UE | 2 | Fundamentals of Databases, Exercise Session (IN0008) Groups 26-50 |
Jungmair, M.
Lehner, S.
Sichert, M.
Vogel, L.
Responsible/Coordination: Kemper, A. |
documents |
|
| UE | 2 | Fundamentals of Databases, Exercise Session (IN0008) Groups 51-75 |
Jungmair, M.
Lehner, S.
Sichert, M.
Vogel, L.
Responsible/Coordination: Kemper, A. |
documents |
Learning and Teaching Methods
Lecture, exercises, problems for individual study, web interface to the data base system HyPer for actively testing SQL queries and self-study of query plans.
Media
Lecture with animated slides, web interface for SQL, Database Normalizer (check relation definitions for compliance with normal forms), tool Interactive Relational Algebra
Literature
- Alfons Kemper, André Eickler: Datenbanksysteme. Eine Einführung. 8., aktualisierte und erweiterte Auflage, Oldenbourg Verlag, 2011
- A. Kemper, M. Wimmer: Übungsbuch: Datenbanksysteme. 3. Auflage Oldenbourg Verlag, 2012
- A. Silberschatz, H. F. Korth, S. Sudarshan: Database System Concepts. Sixth Edition, McGraw-Hill, 2010
- A. Kemper, M. Wimmer: Übungsbuch: Datenbanksysteme. 3. Auflage Oldenbourg Verlag, 2012
- A. Silberschatz, H. F. Korth, S. Sudarshan: Database System Concepts. Sixth Edition, McGraw-Hill, 2010
Module Exam
Description of exams and course work
The academic assessment will be done by a 90 minutes written exam. Assignments checking knowledge verify the familiarity with the main concepts of relational database systems. Transfer assignments and small scenarios check the ability to apply and evaluate these concepts systematically and in a qualified manner.
Exam Repetition
The exam may be repeated at the end of the semester.