Settings
Module Databases and Communication Networks 1, Bachelor Course Media and Communication Computer Science (ER 4)
Module summary

Databases and Communication Networks 1

MKIB3204

Prof. Dr.-Ing. Holger Vogelsang

7 ECTS points / 7 Contact hours

3rd Semester

Computer Science 1, Computer Science 2

none

The students know the current models of communication and database technology and are able to classify and evaluate unknown, e.g. new systems. They are familiar with the advantages and disadvantages of different architectures and will be considered when selecting the architecture for their own products.

In the database area, they are largely familiar with the SQL-92 standard and are able to select, set up and safely operate database systems. The students are able to analyze given facts, to transfer these facts into a normalized data model, to create this data model under SQL and to use the resulting SQL databases under object-oriented languages.

In the field of communication networks, students know the individual layers of the TCP/IP layer model and understand the tasks and service models of each layer. They can characterize and compare different protocols of each layer. They can analyze the requirements of a given application, select the most suitable protocols for that application, and combine them into a functioning network stack. You can also use the client-server approach and socket programming techniques to solve your own problems.

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

MKIB3214.b

Lecture

Prof. Dr. Oliver P. Waldhorst

German

2/2

Module exam

Distributed systems; data transmission and communication networking techniques (circuit/packet switching); Serial / Parallel, fault detection-/protection mechanisms; service and protocol specification; flow control; negotiating qualities of service; multiplexing; time charts and finite state machines as a means of describing protocols; OSI reference model (Layers, protocols, services), protocol-stacks; the physical layer: analog and digital transmission, transmission media, STP/UDP, ISDN, xDSL; the data link layer: character and bitorientierte protocols (BSC, HDLC), Local area networks (LAN e.g.ETHERNET, Token Ring), topology, access procedures; the network layer: connection oriented and connectionless services, routing, congestion control; the transport layer: transport layer classes; RPC; socketprogramming; TCP / IP; the application system: Internet, services and protocols in the Internet environment (Telnet, FTP , SMTP, SNMP, DNS, Web, HTML / HTTP);

• Powerpoint slides

• Word handouts • Tanenbaum: Computer Networks, Pearson Studies, 2003 (german edition) • Collection of old exams and their solutions

Lecture supported by transparencies and Power Point Slides. Student questions are welcome. In parallel to the lecture the participants should control their knowledge using the old exams and their solutions (available on the server).

Course Databases 1

MKIB3214.a

Lecture

Prof. Dr.-Ing. Holger Vogelsang

German

2/2

Module exam

Introduction to information systems, basics of database systems, database organization, data models, database schema, architecture: 3-layer model, client-server architecture, language interfaces: SQL92 (queries, DDL, DML), SQL:2003 (object-oriented extensions, NF2), JDBC, recovery and transactions, ERM, mapping of 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

MKIB3224

Exercise

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

German

2/2

Exercise 1 Semester (not graded)

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.

Translated with www.DeepL.com/Translator

  • Script
  • Sample databases
  • Programming framework
  • 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

Supervised laboratory with final presentation on the computer, independent work, preparation for follow-up, writing a laboratory report on the tasks.

Course New Lecture

MKIB3234

Laboratory

Prof. Dr. Oliver P. Waldhorst

German

1/1

Laboratory Work 1 Semester (not graded)