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 |
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.