inf007 - Information Systems I (Complete module description)

Module label	Information Systems I
Module code	inf007
Credit points	6.0 KP
Workload	180 h
Institute directory	Department of Computing Science
Applicability of the module	Bachelor's Programme Business Informatics (Bachelor) > Aufbaucurriculum - Pflichtbereich Bachelor's Programme Computing Science (Bachelor) > Aufbaumodule Bachelor's Programme Economics and Business Administration (Bachelor) > Studienrichtung Wirtschaftsinformatik Dual-Subject Bachelor's Programme Computing Science (Bachelor) > Aufbaumodule (60 KP) Master of Education Programme (Vocational and Business Education) Computing Science (Master of Education) > Pflichtbereich
Responsible persons	Wingerath, Wolfram (module responsibility) Lehrenden, Die im Modul (authorised to take exams)
Prerequisites	No participant requirement
Skills to be acquired in this module	This module introduces the core concepts, languages and architectures of databases. In software systems these concepts are important. Professional competence The students: name the core concepts of the languages and architectures of databases (especially) select data models integrate structuring concepts of information systems in their designs Methodological competence The students: design database systems appropriatelyanalyse problems from the field of database-supported information systems and solve them appropriately Social competence The students: enhance their ability to work in a team Self-competence The students: reflect their problem-solving behaviour with regard to the information processing concepts
Module contents	Relational data models Relational algebra and its implementation in SQL (the standard of databases) Database design on different abstractions (conceptual and logical design) Normalisation - Data base architectures Distributed and active databases Object-oriented, object-related and XML-based database systems
Recommended reading	Ramez Elmasri und Shamkant B. Navathe (2016), Fundamentals of Databases Systems, 7th Revised edition, Pearson/Addison Wesley.
Links
Language of instruction	German
Duration (semesters)	1 Semester
Module frequency	annual
Module capacity	unlimited
Teaching/Learning method	V+Ü

Type of course	SWS	Frequency	Workload of compulsory attendance
Lecture	3	WiSe	42
Exercises	1	WiSe	14
Total module attendance time			56 h

Examination	Prüfungszeiten	Type of examination
Final exam of module	At the end of the lecture period	Written or oral exam