htw saar
Back to Main Page

Choose Module Version:

flag

Databases

Module name (EN): Databases
Degree programme: Computer Science and Web Engineering, Bachelor, ASPO 01.10.2018
Module code: DFBI-323
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):
None.
Recommended as prerequisite for:
Module coordinator:
Prof. Dr. Klaus Berberich
Lecturer: Prof. Dr. Klaus Berberich

[updated 06.03.2017]
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]
[Sat Jul 11 12:59:47 CEST 2020, CKEY=kd, BKEY=dfi2, CID=DFBI-323, LANGUAGE=en, DATE=11.07.2020]