htw saar
Back to Main Page

Choose Module Version:

Deutsch

Databases

Module name (EN): Databases
Degree programme: Applied Informatics, Bachelor, ASPO 01.10.2017
Module code: PIB-DB
Hours per semester week / Teaching method: 3V+1P (4 hours per week)
ECTS credits: 5
Semester: 3
Mandatory course: yes
Language of instruction:
German
Assessment:
Written exam
Curricular relevance:
DFBI-323 Computer Science and Web Engineering, Bachelor, ASPO 01.10.2018, semester 3, mandatory course
KIB-DB Computer Science and Communication Systems, Bachelor, ASPO 01.10.2017, semester 3, mandatory course
PIB-DB Applied Informatics, Bachelor, ASPO 01.10.2017, semester 3, mandatory course
Workload:
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-MAT1 Mathematics 1
PIB-PRG1 Programming 1


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


[updated 02.10.2017]
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 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 19.02.2018]
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. NoSQL

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

[updated 19.02.2018]
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, 2013
 
Wiese Lena: Advanced Data Management, De Gruyter, 2015

[updated 19.02.2018]
Module offered in:
WS 2019/20, WS 2018/19
[Mon Jul 22 22:56:32 CEST 2019, CKEY=kd, BKEY=pi2, CID=PIB-DB, LANGUAGE=en, DATE=22.07.2019]