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 2025
  

Course unit titleDatabases
Course unit code074703055203
Language of instructionEnglish
Type of course unit (compulsory, optional)Compulsory optional
Semester when the course unit is deliveredWinter Semester 2025
Teaching hours per week2
Year of study2025
Level of course unit (e.g. first, second or third cycle)First Cycle (Bachelor)
Number of ECTS credits allocated3
Name of lecturer(s)Markus SEEBERGER
Heidi WEBER


Prerequisites and co-requisites

Basic programming knowledge

Course content
  • Basic principles of relational databases
  • System architectures (N-tier, Cloud)
  • Entity-relationship model as a data modelling technique
  • SQL
  • Transactions, data integrity and views
  • Data quality
  • XML and protocols for data exchange
  • Data-serialization formats (JSON etc.)
  • Big Data
  • Data analytics (timeseries and evaluation etc.)
  • Time-series databases
Learning outcomes

Students who pass this course are able to explain

  • how all the information systems of an enterprise work together and

  • how data generated by embedded systems are made up to be sent to those host systems.

In practice they are able to

  • work with databases and structure simple solutions

  • define the function of a new database solution

  • analyze complex data

They

  • know what modern database systems are about and

  • can select proper solutions

Planned learning activities and teaching methods

Lectures, exercises and case studies, group work

Assessment methods and criteria

Written examination, participation, immanent examination character

Comment
Recommended or required reading

  • Banzal, S. (2020): XML basics. Duxbury: Mercury Learning and Information.

  • Beaulieu, Alan (2020): Learning SQL: Generate, Manipulate, and Retrieve Data. Online im Internet: URL: https://go.exlibris.link/t0l84Ymb

  • Elmasri, Ramez; Navathe, Shamkant B. (2017): Fundamentals of Database Systems, Global Edition. 7th Revised edition. Pearson Education Limited. Online im Internet: URL: https://go.exlibris.link/0N7jcPHx

  • Kline, Kevin u.a. (2017): SQL in a Nutshell: A Desktop Quick Reference Guide. 4th edition. O'Reilly UK Ltd.

  • Kofler, Michael (2022): Datenbanksysteme – Das umfassende Lehrbuch für Ausbildung, Beruf und Studium.

  • Laudon, Kenneth C; Laudon, Jane Price (2020): Management information systems: managing the digital firm. 16. Aufl. Pearson Education Canada.

  • Silberschatz, Abraham; Korth, Henry F; Sudarshan, S (2020): Database system concepts. Online im Internet: URL: https://go.exlibris.link/VQjTBBBs

  • Steiner, René (2021): Grundkurs relationale Datenbanken: Einführung in die Praxis der Datenbankentwicklung für Ausbildung, Studium und IT-Beruf. 10., aktualisierte Auflage. Wiesbaden: Springer Vieweg. Online im Internet: URL: https://go.exlibris.link/qv010Zpd

  • Studer, Thomas (2019): Relationale Datenbanken: Von den theoretischen Grundlagen zu Anwendungen mit PostgreSQL. Berlin, Heidelberg: Springer Berlin Heidelberg. Online im Internet: DOI: 10.1007/978-3-662-58976-2

  • Umanath, Narayan S.; Scamell, Richard W. (2014): Data Modeling and Database Design. Revised. Australia: Cengage Learning.

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

Face-to-face instruction

Winter Semester 2025go Top