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

Databases and Communication Networks 1

MKIB320

Prof. Dr.-Ing. Holger Vogelsang

7 ECTS points / 6 Contact hours

3rd Semester

Theoretical Computer Science, Mathematics 1, Computer Science 1

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

MKIB321.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

MKIB321.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

MKIB322

Laboratory

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

German

3/2

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.