The module teaches the basics and practical skills in database systems and communication networks.
Competence objectives in the field of databases:
Competence goals in the area of communication networks:
The module promotes analytical thinking, practical problem-solving skills and teamwork and provides a foundation for topics such as network security and distributed systems.
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:
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.
In the lab, students apply practical knowledge and skills to consolidate the content of the lecture of the same name. After completing the lab, they will be able to analyze, configure and programmatically implement network protocols in various layers and measure and evaluate the performance of network applications.
After successful participation, students will be able to:
The laboratory includes the following experiments, which are carried out in teams of 2-4 people:
The experiments are carried out in a virtual environment as group work. The students document their results and present them at the end. The examination consists of the successful completion of the four laboratory experiments and the presentation of the results. The workload is 30 hours, including 15 hours of attendance time and 15 hours of independent preparation and follow-up work.
The lecture covers the following topics:
The knowledge learned in "Databases 1" is deepened and practiced in group work. The interaction of a database with a higher programming language (Java) is understood. The use of SQL (DCL; DML; DDL), transactions and isolation levels and the avoidance of deadlocks is mastered.
A database application for warehouse management will be designed and prototypically implemented. This includes the setup of a DB schema, the design and testing of SQL queries, the use of transactions and transaction levels as well as the programming of queries and transactions with Java using JDBC based on Oracle (the preparation for the laboratory should be done in PostgreSQL or MySQL).
Finally, several given verbal facts are analyzed, transferred to an Entity Relationship model, normalized, transferred to a physical schema and finally created in SQL. Finally, the handling of the OR mapper Hibernate is practiced.
Supervised laboratory with final presentation on the computer, independent work, preparation for follow-up, writing a laboratory report on the tasks.