Module Databases and Communication Networks 1, Media and Communication Computer Science (Bachelor) (ER 3)
The module teaches the basics and practical skills in database systems and communication networks.
Competence objectives in the field of databases:
- Students can model, normalize and implement relational databases.
- They are proficient in SQL (DDL, DML, DCL), transaction management, JDBC and OR mapping (Hibernate).
- They develop database applications independently and integrate them into programming languages such as Java.
- Teamwork and problem-solving skills are encouraged through practice-oriented projects.
Competence goals in the area of communication networks:
- Students understand the architecture and functionality of networks and analyze protocols such as HTTP, TCP, UDP, IPv4/IPv6.
- They plan, configure and evaluate networks, including routing and subnetting.
- They implement protocol functions and use tools for network analysis and fault diagnosis.
- They are able to analyze and evaluate network performance indicators.
The module promotes analytical thinking, practical problem-solving skills and teamwork and provides a foundation for topics such as network security and distributed systems.
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);
• 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).
The lecture covers the following topics:
- Introduction to information systems
- Basics of database systems
- Database organization
- Data models
- Database schema
- Architecture: 3-tier model, client-server architecture
- Current SQL standard (queries, DDL, DML, in particular SQL:2003 with object-oriented extensions, NF2, window functions)
- Transactions
- JDBC
- ER modeling
- Mapping 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
M.Sc. Amir Bukhari
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