252-0846-AAL  Computer Science II

SemesterFrühjahrssemester 2020
DozierendeF. Friedrich Wicker, H. Lehner
Periodizitätjedes Semester wiederkehrende Veranstaltung
KommentarBelegung ist NUR erlaubt für MSc Studierende, die diese Lerneinheit als Auflagenfach verfügt haben.

Alle anderen Studierenden (u.a. auch Mobilitätsstudierende, Doktorierende) können diese Lerneinheit NICHT belegen.

KurzbeschreibungTogether with the introductory course Informatics I this course provides the foundations of programming and databases. This course particularly covers algorithms and data structures and basics about design and implementation of databases. Programming language used in this course is Java.
LernzielBasing on the knowledge covered by lecture Informatics I, the primary educational objectives of this course are
- constructive knowledge of data structures and algorithms amd
- the knowledge of relational databases and
When successfully attended the course, students have a good command of the mechanisms to construct an object oriented program. They know the typically used control and data structures and understand how an algorithmic problem is mapped to a sufficiently efficient computer program. They have an idea of what happens "behind the secenes" when a program is translated and executed. The know how to write database queries and how to design simple databases.
Secondary goals are an algorithmic computational thinking, undestanding the possibilities and limits of programming and to impart the way of thinking of a computer scientist.
InhaltWe discuss the paradigm of object oriented programming, typical data structures and algorithms and design principles for the design and usage of relational databases.
More generally, formal thinking and the need for abstraction and importance of appropriate modelling capabilities will be motivated. The course emphasizes applied computer science. Concrete topics are complexity of algorithms, divide and conquer-principles, recursion, sort- and search-algorithms, backtracking, data structures (lists, stacks, queues, trees) and data management in relational data bases.
SkriptThe slides will be available for download on the course home page.
LiteraturHanspeter Mössenböck, Sprechen Sie Java?, dpunkt Verlag, 5. Auflage 2014.

Robert Sedgewick, Kevin Wayne, Einführung in die Programmierung mit Java. Pearson, 2011

Thomas Ottmann, Peter Widmayer, Algorithmen und Datenstrukturen, Springer 2012

T. Cormen, C. Leiserson, R. Rivest, C. Stein, Algorithmen - Eine Einführung, Oldenbourg, 2010

Kemper, Eickler: Datenbanksysteme: Eine Einführung. Oldenbourg Verlag, 9. Auflage, 2013
Voraussetzungen / BesonderesPrerequisites are knowledge and programming experience according to course 252-0845-00 Computer Science I (D-BAUG).