Course Info
| Module [Module Number] | CM Information Systems II |
| Regular Cycle | Winter Term |
| Teaching Form | Lecture and tutorial |
| Examination Form | Written test: WT (90) |
| Teaching Language | German |
| ECTS | 6 |
| Instructor | Prof. Dr. Christoph Rosenkranz, Florian Wagner |
| KLIPS 2.0 | Link |
Module Content
- Relational model and relational algebra
- Relational query languages (SQL)
- Conceptual data modelling (e.g., Entity Relationship Model)
- Relational database design
- Normalization (1.-3. normal form, BCNF)
- Development process of database systems
- Data organization, data management, data protection and privacy • Transactions, Concurrency Control, Indices
Learning Objectives
Students …
- know and understand the relevant methods and theories for the points mentioned above under „Module content“.
- know and understand basic theories in the field of relational databases and data management.
- apply theories in the field of relational databases and data management in pre-structured contexts (e.g. case studies) in a solution-oriented way.
- use methods in the field of relational databases and data management in pre-structured contexts in a solution-oriented way.
- develop an understanding of the impact of decisions that take into account environmental, economic, social or ethical criteria.