Information on individual educational components (ECTS-Course descriptions) per semester | |
| Degree programme: | Bachelor International Business Administration Part-time |
| Type of degree: | FH Bachelor´s Degree Programme |
| Part-time | |
| Winter Semester 2024 | |
| Course unit title | Data Management and Database Systems |
| Course unit code | 025008031501 |
| Language of instruction | German |
| Type of course unit (compulsory, optional) | Compulsory |
| Semester when the course unit is delivered | Winter Semester 2024 |
| Teaching hours per week | 2 |
| Year of study | 2024 |
| Level of course unit (e.g. first, second or third cycle) | First Cycle (Bachelor) |
| Number of ECTS credits allocated | 3 |
| Name of lecturer(s) | Jens SCHUMACHER |
| Prerequisites and co-requisites | |
Content of the courses Basics of Digitalization and Introduction to Programming | |
| Course content | |
| |
| Learning outcomes | |
Data is described as the "new oil" in the information society. Company-relevant data, which is stored in databases and made available across applications, is the basis of most information and communication systems. The aim of this course is to learn the modelling, implementation and querying of relational database systems based on an overview of database architectures. The students know different database architectures and can sketch them. They 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 can create an ER model based on a description of a subsection of the entrepreneurial reality. Furthermore, they can convert the model into a relational data model using tools. Finally, they are able to analyse and, if necessary, optimise a given relational data model through normalisation. | |
| Planned learning activities and teaching methods | |
| |
| Assessment methods and criteria | |
Written exam, exercises, individual weighting as determined by the teachers, announced at the beginning of the semester. | |
| Comment | |
None | |
| 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. Sebastopol, CA: O’Reilly UK Ltd. Silberschatz, Abraham; Korth, Henry F.; Sudarshan, S. (2014): Database System Concepts. 6th edition. International Edition edition. New York, NY: Mcgraw-Hill Education. | |
| Mode of delivery (face-to-face, distance learning) | |
Classes with compulsory attendance in individual teaching units (simulation game, seminars, excursions) supplemented by asynchronous teaching units for the presentation of elementary basics, which are assumed as given knowledge |
| Winter Semester 2024 | go Top |