|
|
Module code: PRI-DB |
|
3V+1P (4 hours per week) |
5 |
Semester: 3 |
Mandatory course: yes |
Language of instruction:
German |
Assessment:
Written exam, Duration 120 min.
[updated 13.10.2024]
|
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, SO 01.10.2023
, 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):
None.
|
Recommended as prerequisite for:
|
Module coordinator:
Prof. Dr. Klaus Berberich |
Lecturer: Prof. Dr. Klaus Berberich
[updated 07.08.2019]
|
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]
|