Computer Applications
Degree programme | Mechatronics |
Subject area | Engineering Technology |
Type of degree | Bachelor Full-time Winter Semester 2024 |
Course unit title | Computer Applications |
Course unit code | 024515053203 |
Language of instruction | English |
Type of course unit (compulsory, optional) | Compulsory |
Teaching hours per week | 3 |
Year of study | 2024 |
Level of the course / module according to the curriculum | |
Number of ECTS credits allocated | 3 |
Name of lecturer(s) | Valmir BEKIRI, Ralph HOCH, Rene PILZ |
Fundamentals of structured and object oriented programming computer systems. (data-types, control structures etc.)
- Introduction of computer networks and protocols
- Typical network-wide applications
- ISO-OSI layer model
- (Web) services
- Application security
- Interfaces between heterogeneous systems (data exchange formats, current web technologies)
- HTT protocol (HTTP)
- Practical examples from the manufacturing environment
- Relational databases: design (ERM), SQL (DLL+DML), normal forms, communication DBMS-Client
- Administration tools for DBMS: PhpMyAdmin and MySQL Workbench
- Students can name the advantages and disadvantages of different architectural models of IT systems and can assess the use of such systems in the field of manufacturing.
- Students are able to model and use relational databases.
- Students can interpret ER models and convert them into functioning relational databases.
- The students master basic database access via SQL (DDL + DML).
Lecture with exercises, self-study, additional working assignments in groups.
Case study (in groups) with final presentation (100%)
Not applicable
- Tannenbaum Andrew (2012): Computer Networks, (5th Ed.) Pearson
- Ramez A. Elmasri, Shamkant B. Navathe (2016): Grundlagen von Datenbanksystemen (7rd Ed.) Pearson
- Philip Ackermann (2021): Webentwicklung - Rheinwerk
Face-to-face; compulsory attendance: in case of absence read study regulations, page 9.