FHV Vorarlberg University
of Applied Sciences
Info event at FHV

Databases

Degree programme Mechatronics
Subject area Engineering Technology
Type of degree Bachelor full-time
Type of course unit (compulsory, optional) Compulsory optional
Course unit code 074703055203
Teaching units 30
Year of study 2025
Name of lecturer(s) Heidi WEBER, Markus SEEBERGER
Requirements and Prerequisites

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