Relational Databases
| Degree programme | Computer Science - Digital Innovation |
| Subject area | Engineering & Technology |
| Type of degree | Bachelor Part-time Winter Semester 2023 |
| Course unit title | Relational Databases |
| Course unit code | 083121110103 |
| Language of instruction | German |
| Type of course unit (compulsory, optional) | Compulsory |
| Teaching hours per week | 3 |
| Year of study | 2023 |
| Level of the course / module according to the curriculum | |
| Number of ECTS credits allocated | 5 |
| Name of lecturer(s) | Verena FASTENBAUER, Peter REITER |
None
- Architecture of database application systems
- ANSI-SPARC architecture
- Structured database design
- ER Modeling describing conceptual data model
- Transformation of ER Models into relational databases
- Normalization of relational data models
- SQL
- Transactions and ACID principle
Most information systems are based on company-relevant data that is stored in databases and made available across applications. These frequently newly generated and reorganized data are also referred to as the "new oil" in the information society. In addition to network-like and hierarchically organized database architectures, relational database systems play an important role.
Theoretical and methodological know-how (T/M):
- Students know different database architectures and can sketch 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.
- Students create ER models based on a description of the business reality. Moreover, they transform the model into a relational data model and implement it with SQL commands.
- Students analyse and optimise relational data models by normalisation. The goal is a normalization up to the 4th normalization stage.
Social and communicative competencies (S/K) and personal competences (P):
- Students solve tasks independently and on time (reliability) and to demonstrate and explain the solutions (expressiveness and appearance).
- Students understand the solutions of others, can make constructive suggestions for improvement and deal with feedback (critical ability) as well as reflect on their own abilities and limits (self-reflection).
- Ability and willingness to acquire new knowledge independently and to learn from successes and failures (learning competence and motivation).
Integrated course: 1 THW together and 2 THW in two groups.
Lectures and weekly exercises, which have to be implemented, submitted and presented live in the next session by randomly selected students and discussed in the group.
- Evaluation of exercises (50 %)
- Final written exam (50 %) of theoretical foundations and their application 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.
None
- 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: 21.05.2018).
- Silberschatz, Abraham; Korth, Henry F.; Sudarshan, S. (2014): Database System Concepts. 6th edition. International Edition edition. New York, NY: Mcgraw-Hill Education.
In-class lecture: Compulsory attendance in the practice session