htw saar Piktogramm QR-encoded URL
Back to Main Page Choose Module Version:
XML-Code

flag



Databases

Module name (EN):
Name of module in study programme. It should be precise and clear.
Databases
Degree programme:
Study Programme with validity of corresponding study regulations containing this module.
Applied Informatics, Bachelor, ASPO 01.10.2022
Module code: PIB-DB
SAP-Submodule-No.:
The exam administration creates a SAP-Submodule-No for every exam type in every module. The SAP-Submodule-No is equal for the same module in different study programs.
P221-0018
Hours per semester week / Teaching method:
The count of hours per week is a combination of lecture (V for German Vorlesung), exercise (U for Übung), practice (P) oder project (PA). For example a course of the form 2V+2U has 2 hours of lecture and 2 hours of exercise per week.
3V+1P (4 hours per week)
ECTS credits:
European Credit Transfer System. Points for successful completion of a course. Each ECTS point represents a workload of 30 hours.
5
Semester: 3
Mandatory course: yes
Language of instruction:
German
Assessment:
Written exam, Duration 120 min.

[updated 13.10.2024]
Applicability / Curricular relevance:
All study programs (with year of the version of study regulations) containing the course.

DFBI-323 (P610-0219) Computer Science and Web Engineering, Bachelor, ASPO 01.10.2018 , semester 3, mandatory course
DFIW-DB (P610-0183) Computer Science and Web Engineering, Bachelor, ASPO 01.10.2019 , semester 3, mandatory course
KIB-DB (P222-0009) Computer Science and Communication Systems, Bachelor, ASPO 01.10.2021 , semester 3, mandatory course
KIB-DB (P222-0009) Computer Science and Communication Systems, Bachelor, ASPO 01.10.2022 , semester 3, mandatory course
PIB-DB (P221-0018) Applied Informatics, Bachelor, ASPO 01.10.2022 , semester 3, mandatory course
PRI-DB (P222-0009) Production Informatics, Bachelor, ASPO 01.10.2023 , semester 3, mandatory course
Workload:
Workload of student for successfully completing the course. Each ECTS credit represents 30 working hours. These are the combined effort of face-to-face time, post-processing the subject of the lecture, exercises and preparation for the exam.

The total workload is distributed on the semester (01.04.-30.09. during the summer term, 01.10.-31.03. during the winter term).
60 class hours (= 45 clock hours) over a 15-week period.
The total student study time is 150 hours (equivalent to 5 ECTS credits).
There are therefore 105 hours available for class preparation and follow-up work and exam preparation.
Recommended prerequisites (modules):
PIB-INF1 Informatics 1
PIB-MA1 Mathematics 1
PIB-PR1 Programming 1


[updated 04.07.2024]
Recommended as prerequisite for:
PIB-PA Project work
PIB-PRA Work Experience Phase
PIB-WEB Principles of Web Development


[updated 03.07.2024]
Module coordinator:
Prof. Dr. Klaus Berberich
Lecturer: Prof. Dr. Klaus Berberich

[updated 28.09.2016]
Learning outcomes:
After successfully completing this module, students will be able to use relational database systems in practice. To do so, they will learn data modelling techniques and be able to apply them to problems in real life. Students will understand the relational model and relational algebra as the mathematical foundations of relational database systems. They will be capable of deriving a relational schema from a modelled section from the real world. Students will be able to assess its quality on the basis of relational normal forms (1NF, 2NF, 3NF) and improve it if necessary by converting it into a higher normal form. They will also be able to formulate concrete information requirements as expressions of relational algebra. Students will be familiar with the essential commands of the Structured Query Language (SQL) and can use them to change the schema of a database and the data stored in it. In addition, they will also be able to express a given need for information as a query in SQL and to understand and communicate a given SQL query. Students will understand the central concept of the transaction and can define each of the ACID properties and illustrate them with examples. They will be able to name different types of indexes in relational database systems and can use them depending on the situation. In order to solve more complex problems with the help of a relational database system, students will be familiar with the basic language components of procedural extensions (e. g. Oracle PL/SQL and Microsoft TransactSQL) of SQL. In addition, students will be familiar with interfaces (e. g. ODBC and JDBC) for accessing a relational database system from an application. They will be capable of accessing an existing relational database from a programming language known to them (e. g. Java, Python or C) by means of these interfaces. Finally, students will know alternatives to relational databases (e. g. document-oriented databases and graph databases) and can name differences.

[updated 13.10.2024]
Module content:
1. Introduction
2. Database design
3. Relational model and relational algebra
4. Structured Query Language (SQL)
5. Relational design theory
6. Data integrity
7. Transaction management
8. Database tuning
9. Security aspects
10. Programming with SQL
11. Database interfaces
12. Non-relational databases

[updated 13.10.2024]
Teaching methods/Media:
Transparencies, script, example databases in SQLite, practical and theoretical exercises.

[updated 13.10.2024]
Recommended or required reading:
Kemper Alfons und Eickler André: Datenbanksysteme - Eine Einführung, De Gruyter, 2015
 
Saake Gunter und Sattler Kai-Uwe: Datenbanken - Konzepte und Sprachen, mitp Professional, 2018
 
Wiese Lena: Advanced Data Management, De Gruyter, 2015

[updated 13.10.2024]
Module offered in:
WS 2024/25, WS 2023/24, WS 2022/23, WS 2021/22, WS 2020/21, ... 
[Sat Nov 23 08:58:23 CET 2024, CKEY=kd, BKEY=pi2, CID=PIB-DB, LANGUAGE=en, DATE=23.11.2024]