Information on individual educational components (ECTS-Course descriptions) per semester

Basic knowledge of set theory and functions.
Practical knowledge of at least one programming language.

Computer-aided information systems have the task of collecting relevant information, making it available and storing it persistently. Persistent data play a crucial role in long-term storage and in the exchange of information between different applications and systems. Database management systems play a central role in this. This course focuses on large amounts of structured data and relational databases.

• Architecture of database application systems (ANSI-SPARC architecture)
• Structured database design (from technical conception to implementation)
• Entity relationship modeling to describe conceptual data models
• Basics of relational databases
  (a) the relational model
  (b) the language SQL (data manipulation, schema definition, rights management and transaction control)
  (c) Design guidelines and normal forms
• Physical data structures and query execution
• Transaction management
• Transactions, concurrency and recovery
• Development of DB applications
• Connection of databases to application programs (object-relational mapping ORM)
• Data exchange and transfer
• The family of XML technologies

Technical and methodological competence (F / M)

• The students are familiar with various database architectures and can outline them.
• Students know the advantages and disadvantages of entity relationship models (ER models) and relational data models. They know the different language elements and can interpret the models.
• The students are able to develop data structures in relational and hierarchical (XML) technology and to create them in database management systems.
• Students are able to analyze, optimize and integrate existing data structures into programs.
• Students know the language elements of the SQL language and can use them
  (a) Implement verbal questions in database queries
  (b) Implement database schemas
  (c) Configure user rights of a database.
• The students are able to explain the concepts of transaction management.
• Students can connect an application program with the appropriate tools to a database management system.

Social and communicative skills (S / K) and self-skills (S)

• Students can solve tasks independently and on time (reliability) and communicate and justify the solutions created (expressiveness and demeanor).
• The students understand the solutions of others, can make constructive suggestions for improvement and deal with feedback (ability to criticize) and reflect on their own abilities and limits (self-reflection ability).
• Ability and willingness to acquire new knowledge independently and to learn from successes and failures (learning competence and motivation).

Frontal instruction with lectures on theory. Practical examples and exercises in the seminars. Presentation of the solutions by the students.

• Assessment of the exercises 25%
• Written exam 25%
• Final written exam 50% in the theoretical basics reproduced, classified and used in simple practical tasks

For a positive grade, a minimum of 50% of the possible points must be achieved in each part of the examination.

Not applicable

Elmasri, Ramez; Navathe, Shamkant B. (2015): Fundamentals of Database Systems. 7. Aufl. Hoboken, NJ: Pearson. 

Jarosch, Helmut (2016): Grundkurs Datenbankentwurf: Eine beispielorientierte Einführung für Studierende und Praktiker. 4., überarb. und aktualisierte Aufl. 2016 edition. Wiesbaden: Springer Vieweg. 

Kline, Kevin u.a. (2018): SQL in a Nutshell: A Desktop Quick Reference Guide. 4th edition. O'Reilly UK Ltd. 

PostgreSQL Global Development Group (o. J.): PostgreSQL. Online im Internet: URL: https://www.postgresql.org (Zugriff am: 23.02.2020).

Silberschatz, Abraham; Korth, Henry; Sudarshan, S. (2019): Database System Concepts. 7. Auflage. International. Place of publication not identified: McGraw-Hill Education Ltd. 

Bauer, Christian; King, Gavin; Gregory, Gary (2015): Java Persistence with Hibernate. 2nd Aufl. Shelter Island, NY: Manning Publications. 

Date, C. J. (2003): An Introduction to Database Systems. Subsequent. Boston: Pearson.

Classroom teaching, attendance in the seminars is mandatory