| Prerequisites and co-requisites |
Basic knowledge of set theory and functions.
Practical knowledge of at least one programming language. |
| Course content |
Computer-based information systems have the tasks of capturing relevant information, providing it and storing it persistently. Persistent data plays a crucial role, especially in long-term storage and the exchange of information between different applications and systems. Database management systems play a central role in this. The focus of this course is on large amounts of structured data and relational databases.
- Architecture of database application systems (ANSI-SPARC architecture)
- Structured database design (from conceptual design to implementation)
- Entity-relationship modeling for describing conceptual data models
- Fundamentals of relational databases
- (a) The relational model
- (b) The SQL language (data manipulation, schema definition, rights management, and transaction control)
- © Design guidelines and normal forms
- Physical data structures and query execution
- Transaction management
- Transactions, concurrency, and recovery
- Development of database applications
- Connecting databases to application programs (object-relational mapping ORM)
- Data exchange and transmission
- The family of XML technologies
|
| Learning outcomes |
Subject and Method Competence (F/M)
- The students know various database architectures and can outline them.
- The students understand 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 capable of developing data structures in both relational and hierarchical (XML) technologies and creating them in database management systems.
- The students are able to analyze, optimize and integrate existing data structures into programs. The students know the language elements of SQL and can use them to:
- (a) translate verbal queries into database queries
- (b) implement database schemas
- © configure user rights in a database The students are capable of explaining the concepts of transaction management. The students can securely connect an application program to a database management system using appropriate tools.
Social and Communicative Competence (S/K) and Self-Competence (S)
- The students can independently and punctually solve assigned tasks (reliability) and communicate and justify their solutions (expressiveness and demeanor).
- The students understand the solutions of others, can provide constructive improvement suggestions, handle feedback (ability to handle criticism) and reflect on their own abilities and limits (self-reflection).
- Ability and willingness to acquire new knowledge independently and learn from successes and failures (learning competence and motivation).
|
| Planned learning activities and teaching methods |
Frontal instruction with lectures on theory. Practical examples and exercises in the seminars. Presentation of the solutions by the students. |
| Assessment methods and criteria |
Assessment of the exercises 25%
Written exam 25%
Final written exam in the theoretical basics reproduced, classified and used in simple practical tasks 50%
For a positive grade, a minimum of 50% of the possible points must be achieved in each part of the examination. |
| Comment |
Not applicable |
| Recommended or required reading |
- 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.
|
| Mode of delivery (face-to-face, distance learning) |
On-site course, attendance in the seminars is mandatory |