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

Settings

Menu type

Color scheme

Menu color

Input color

Module summary
Module name Databases and Communication Networks 1
Internal number MKIB3203
Coordinator Prof. Dr.-Ing. Holger Vogelsang
Extent 7 ECTS points / 6 Contact hours
Semester 3rd Semester
Pre-requisites with regard to content Theoretical Computer Science, Mathematics 1, Computer Science 1
Pre-requisites according to the examination regulations none
Competencies 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.
Assessment Written Exam 120 Min. (graded)

Course Communication Networks 1
Internal number MKIB3213.b	Type/mode Lecture
Lecturer Prof. Dr. Oliver P. Waldhorst	Language of instruction German
Extent (ECTS/SWS) 2/2	Assessment Module exam
Content 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);
Recommended reading • Powerpoint slides • Word handouts • Tanenbaum: Computer Networks, Pearson Studies, 2003 (german edition) • Collection of old exams and their solutions
Comments 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
Internal number MKIB3213.a	Type/mode Lecture
Lecturer Prof. Dr.-Ing. Holger Vogelsang	Language of instruction German
Extent (ECTS/SWS) 2/2	Assessment Module exam
Content 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.
Recommended reading 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
Internal number MKIB3223	Type/mode Laboratory
Lecturers M.Sc. Amir Bukhari Prof. Dr.-Ing. Holger Vogelsang	Language of instruction German
Extent (ECTS/SWS) 3/2	Assessment Laboratory Work 1 Semester (not graded)
Content 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.
Recommended reading 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
Comments Supervised laboratory with final presentation on the computer, self-work, preparation and after working of lab sessions, prepare a reportof the laboratory tasks.