Modulcode:	infDB-01a
Englische Bezeichnung:	Database Systems
Modulverantwortliche(r):	Prof. Dr. Peer Kröger
Turnus:	jedes Jahr im SS (SS23 SS24)
Präsenzzeiten:	3V 1Ü
ECTS:	5
Workload:	45 h lectures, 15 h exercises,, 90 h self studies
Dauer:	ein Semester
Modulkategorien:	BSc-Inf-A (BSc Inf (21)) 2F-BSc-Inf (2F-BSc Inf (21)) BSc-WInf-A (BSc WInf (21)) NF (Inf. als NF) INF-Math (Inf. als NF) Arch-NFInf21 (Inf. als NF) VWL (Export) EcoQuantFin (Export)
Lehrsprache:	Englisch
Voraussetzungen:

Kurzfassung:

In the lecture the basics of the modeling database systems are taught: the concepts and query languages ​​of the relational data model are discussed, and after a discussion of the structure of database systems an introduction to transaction management and the programming of database applications is given.

Lernziele:

The students

• know different database models
• can conceptually design relational databases
• can work woth transaction concepts
• can use database systems in applications

Lehrinhalte:

• Introduction to database systems
• The relational data model
• Relational Algebra, (SQL, Part 1)
• The Relation Calculus (SQL, Part 2)
• Sorting, grouping and views (SQL, part 3)
• Database modeling with the ER-model
• Normal forms
• Transactions
• Index structures
• Relational request processing
• Application development

Weitere Voraussetzungen:

Prüfungsleistung:

written exam

Lehr- und Lernmethoden:

In the lecture, the material is conveyed in various forms (blackboard, projector), which are shown in Depending on the respective content is chosen. Most of the lecture exist Slides, along with other documents, on the event web page to be provided. Theoretical and practical tasks are presented in the exercises processed on the subject matter taught in the lecture. The solutions are discussed.

Verwendbarkeit:

Literatur:

Will be given in the lecture.

Verweise:

Kommentar: