|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|
|Mandatory course: yes|
|Language of instruction:
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
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
|Recommended as prerequisite for:
PIB-PA Project work
PIB-PRA Work Experience Phase
PIB-WEB Principles of Web Development
Prof. Dr. Klaus Berberich
|Lecturer: Prof. Dr. Klaus Berberich
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.
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
Transparencies, script, example databases in SQLite and Microsoft SQL Server, practical and theoretical exercises.
|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
|Module offered in: |
[Mon May 20 22:56:55 CEST 2019, CKEY=kd, BKEY=pi2, CID=PIB-DB, LANGUAGE=en, DATE=20.05.2019]