Technical Information Systems
| Degree programme | Bachelor Electrical Engineering Dual |
| Subject area | Engineering Technology |
| Type of degree | Bachelor Part-time Winter Semester 2024 |
| Course unit title | Technical Information Systems |
| Course unit code | 074742056303 |
| Language of instruction | English |
| Type of course unit (compulsory, optional) | Compulsory optional |
| Teaching hours per week | 2 |
| Year of study | 2024 |
| Level of the course / module according to the curriculum | |
| Number of ECTS credits allocated | 3 |
| Name of lecturer(s) | Markus SEEBERGER, Heidi WEBER |
Module "Computer Science", Semester 1 to 4
- Information systems in the business environment (eg CAD / CAM, ERP, data warehouse, data mining)
- System Architectures (N-Tier, Cloud)
- Basic principles of relational databases
- Entity relationship model as data modeling technique
- SQL as a database query language
- Transactions, data integrity and views
- XML and protocols for data exchange
- data quality
Upon successful completion of the course, students, will be able to explain the principles and interaction of essential information systems in an operational environment, provide data generated in an embedded system at the required quality for those systems.
Lectures, exercises and case studies, group works
Written examination, collaboration, immanent examination character
-
- Baker, Richard; lnc, mEm (2020): Learning XML: The Ultimate Beginner’s Guide to Learn XML Programming Step by Step. Independently published.
- Beaulieu, Alan (2020): Learning SQL: Generate, Manipulate, and Retrieve Data.
- Elmasri, Ramez; Navathe, Shamkant B. (2016): Fundamentals of Database Systems, Global Edition. 7th Revised edition. Pearson Education Limited.
- Jukic, Nenad; Vrbsky, Susan; Nestorov, Svetlozar (2017): Database systems: introduction to databases and data warehouses.
- Kline, Kevin E.; Kline, Daniel; Hunt, Brand (2008): SQL in a nutshell: a desktop quick reference ; covers MySQL, Oracle, PostgreSQL, and SQL server. 3. ed. Sebastopol, Calif. (u.a.): O’Reilly. Online im Internet: URL: http://vlb-content.vorarlberg.at/fhbscan1/330900085568.pdf.
- Kline, Kevin u.a. (2017): SQL in a Nutshell: A Desktop Quick Reference Guide. 4th edition. O’Reilly UK Ltd.
- Laudon, Kenneth C; Laudon, Jane Price (2020): Management information systems: managing the digital firm. 16th Ed. Pearson Education Canada.
- Meier, Andreas; Kaufmann, Michael (2019): SQL & NoSQL databases. New York, NY: Springer Berlin Heidelberg.
- Petrov, Alex (2019): Database internals: a deep dive into how distributed data systems work. First edition. Sebastopol, CA: O’Reilly Media.
- Powell, Gavin (2020): Database modeling step by step.
Face to face