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

  
Degree programme:Bachelor Mechatronics Fulltime
Type of degree:FH BachelorĀ“s Degree Programme
 Full-time
 Winter Semester 2022
  

Course unit titleComputer Applications
Course unit code024515053203
Language of instructionEnglish
Type of course unit (compulsory, optional)Compulsory
Semester when the course unit is deliveredWinter Semester 2022
Teaching hours per week3
Year of study2022
Level of course unit (e.g. first, second or third cycle)First Cycle (Bachelor)
Number of ECTS credits allocated3
Name of lecturer(s)Valmir BEKIRI
Horatiu O. PILSAN
Kelvin SPARR


Prerequisites and co-requisites

Fundamentals of programming computer systems.

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.

Winter Semester 2022go Top