Module summary |
Databases and Communication Networks 1 |
MINB3205 |
Prof. Dr.-Ing. Holger Vogelsang |
7 ECTS points / 7 Contact hours |
3rd Semester |
Computer Science 2, 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
| |
MINB3214.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
| |
MINB3214.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. | |
|
Course Databases 1 Laboratory
| |
MINB3224 | Exercise |
M.Sc. Amir Bukhari Prof. Dr.-Ing. Holger Vogelsang | 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 | |
| |
Supervised laboratory with final presentation on the computer, independent work, preparation for follow-up, writing a laboratory report on the tasks. |
Course New Lecture
| |
MINB3234 | Laboratory |
Prof. Dr. Oliver P. Waldhorst | German |
1/1 | Laboratory Work 1 Semester (not graded) |