skip to content

Course Info

Module [Module Number]

CM Information Systems II
[1277BBWIF2]

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.