Information on individual educational components (ECTS-Course descriptions) per semester

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
Requirements and Prerequisites

Fundamentals of structured and object oriented programming computer systems. (data-types, control structures etc.)

Course content
  • 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
Learning outcomes
  • 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).
Planned learning activities and teaching methods

Lecture with exercises, self-study, additional working assignments in groups.

Assessment methods and criteria

Case study (in groups) with final presentation (100%)

Comment

Not applicable

Recommended or required reading
  • 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

 

Mode of delivery (face-to-face, distance learning)

Face-to-face; compulsory attendance: in case of absence read study regulations, page 9.