Module Databases and Communication Networks 1, Media and Communication Computer Science (Bachelor) (ER 2)

English language
Compact font

Color scheme

Module summary

Databases and Communication Networks 1

MKIB320

Prof. Dr. Oliver Waldhorst

/

3rd Semester

Informatik 1, Mathematik 1, Theoretische Informatik

none

The module teaches the basics and practical skills in database systems and communication networks.


Competence objectives in the field of databases:

  • Students can model, normalize and implement relational databases.
  • They are proficient in SQL (DDL, DML, DCL), transaction management, JDBC and OR mapping (Hibernate).
  • They develop database applications independently and integrate them into programming languages such as Java.
  • Teamwork and problem-solving skills are encouraged through practice-oriented projects.

Competence goals in the area of communication networks:

  • Students understand the architecture and functionality of networks and analyze protocols such as HTTP, TCP, UDP, IPv4/IPv6.
  • They plan, configure and evaluate networks, including routing and subnetting.
  • They implement protocol functions and use tools for network analysis and fault diagnosis.
  • They are able to analyze and evaluate network performance indicators.

The module promotes analytical thinking, practical problem-solving skills and teamwork and provides a foundation for topics such as network security and distributed systems.

Written Exam 120 Min. (graded)
Course Communication Networks 1

MKIB321.b

Lecture

Prof. Dr. Oliver Waldhorst

German

2/2

60 hours in total, including 30 hours of contact study.

Module exam

In this course, students expand their knowledge of communication networks, in particular by taking an in-depth look at the functionalities and challenges of the layers of the Internet protocol stack. After completing the course, they will be able to analyze, evaluate and practically apply advanced mechanisms and protocols in the application layer, transport layer, network layer and security layer. They will be able to identify complex network problems, combine specific solution modules and develop innovative solutions.

The lecture covers the following topics:

  • Transmission of multimedia content in the application layer, e.g. Netflix and Skype, as well as the basics of secure communication such as TLS and secure email.
  • Transport layer mechanisms, including extensions to TCP such as SACK and CUBIC, as well as new protocols such as QUIC.
  • Network layer with addressing and routing concepts, including IPv6, Software Defined Networking (SDN) and IPsec.
  • Data link layer with a focus on VLANs, MPLS and data center networks.

The lecture is taught in a flipped classroom format. Students prepare for the classroom sessions independently using lecture slides and explanatory videos. In these sessions, the topics are explored in greater depth through case studies and exercises. Online tests offer students the opportunity for self-assessment and to collect bonus points for the exam. The examination consists of a 60-minute written exam, which is part of the module exam "Databases and Communication Networks 2".

The total workload is 75 hours, divided into 25 hours of attendance time, 25 hours of asynchronous learning and 25 hours for exam preparation and follow-up.

  • Slide collection and explanatory videos in the ILIAS system
  • James Kurose, Keith Ross: Computer Networking - A Top-Down Approach, 8th edition, Pearson, 2021
  • Various Internet standards, see https://www.rfc-editor.org
  • Further information in the lecture
Course Databases 1

MKIB321.a

Lecture

Prof. Dr.-Ing. Holger Vogelsang

German

2/2

60 hours in total, including 30 hours of contact study.

Module exam

The lecture covers the following topics:

  • Introduction to information systems
  • Basics of database systems
  • Database organization
  • Data models
  • Database schema
  • Architecture: 3-tier model, client-server architecture
  • Current SQL standard (queries, DDL, DML, in particular SQL:2003 with object-oriented extensions, NF2, window functions)
  • Transactions
  • JDBC
  • ER modeling
  • Mapping entities and relationships to relational data models
  • Normalization
  • OR mapping

  • Script
  • Example databases of the lecture for the common database systems
  • Exercises
  • Sample programs
  • Collection of old exams and their solutions
  • Edwin Schicker, "Datenbanken und SQL", Springer Vieweg, 2017, ISBN: 978-3834817327
  • Gunter Saake, Kai-Uwe Sattler, "Datenbanken - Konzepte und Sprachen", mitp, 2013, ISBN: 978-3286694530
Course Databases 1 Laboratory

MKIB322

Laboratory

Prof. Dr.-Ing. Holger Vogelsang
M.Sc. Amir Bukhari

German

3/2

90 hours in total, including 30 hours of contact study.

Laboratory Work 1 Semester (not graded)

Adatabase application for a flight reservation system is designed and prototypically implemented. This includes setting up a DB scheme, the design and testing of SQL queries, the use of transactions and transaction levels, as well as programming a seat reservation transaction with Java, JDBC and SQLJ-based on Oracle.

Sample database, JUnit test cases, test-GUI; Textbooks:

  • "Grundlagen von Datenbanksystemen", Ausgabe Grundstudium (Taschenbuch) von Ramez Elmasri, Shamkant B. Navathe, Pearson, 2005, ISBN: 3827371538
  • "Datenbanksysteme" von Alfons Kemper, Andre Eickler, Oldenbourg, 2006, ISBN: 3486576909
  • "Datenbanken & Java. JDBC, SQLJ, ODMG und JDO" von Gunter Saake, Kai-Uwe Sattler, Dpunkt Verlag, 2003, ISBN: 3898642283

Supervised laboratory with final presentation on the computer, self-work, preparation and after working of lab sessions, prepare a reportof the laboratory tasks.