Data Management aims at the data view of information systems. It will discuss conceptual views (Entity Relationship Model, relational data model) and data implementation via SQL in relational data bases (Data Description Language, Data Manipulation Language, Data Control Language and Queries). Furthermore, transaction concepts (ACID) and locking mechanisms (two phase protocols) will be introduced. There will be lectures, excercises with MySQL data bases (or other DBMS) and case studies. Students will be asked to present their results to other students in the excercise hours.

Learning outcomes

Academic: Students should become able to structure, model and implement data of information systems in data base management systems (DBMS) on methodical grounding. Soft skills: Sole and team work with required excercises. Learning soft skills in the area of project management, group discussions and result presentations.
Number of credit hours per week 4
Course eligibility Compulsory
Presence of students On-campus