352-0521/03 – Information Systems (IS)
Gurantor department | Department of Control Systems and Instrumentation | Credits | 4 |
Subject guarantor | doc. Ing. Lenka Landryová, CSc. | Subject version guarantor | doc. Ing. Lenka Landryová, CSc. |
Study level | undergraduate or graduate | Requirement | Compulsory |
Year | 1 | Semester | summer |
| | Study language | Czech |
Year of introduction | 2021/2022 | Year of cancellation | |
Intended for the faculties | FS | Intended for study types | Follow-up Master |
Subject aims expressed by acquired skills and competences
Students learn the principles of information systems, solving bulk data processing, records, etc. Students will gain an overview of available database systems from the desktop SQL Server, including analytical tools and master the methods and procedures of small and medium-scale database tasks with an emphasis on database modeling , UML, teamwork, and output to the Internet.
Teaching methods
Lectures
Tutorials
Project work
Summary
Subject Information Systems determines the profile of the graduates in the branch of Automatic Control and Engineering Informatics. Its objective is to introduce students to the principles of creating data structures and the data processing, data recording and system problem solving. Student will deal with methods and procedures for database systems of small and middle range with emphasis on the team work. A part of the subject is also implementations for database throught Internet.
Compulsory literature:
Recommended literature:
PLANDOR, David, 2017. A diagnostic expert system as a tool for technology improvement support. Ostrava. Dissertation work. Department of Control Systems and Instrumentation, VŠB-TU Ostrava. Vedoucí práce Lenka Landryová.
Additional study materials
Way of continuous check of knowledge in the course of semester
Tasks assigned for the semestral work in LMS with a set date of submission, test at the end of the semester.
E-learning
lms.vsb.cz
Other requirements
A student will submit his/her project documentation.
Prerequisities
Subject has no prerequisities.
Co-requisities
Subject has no co-requisities.
Subject syllabus:
IS Design - UML (UML standard, language syntax, life cycle).
Analysis of IS requirements, use cases, scenarios.
Dynamic diagrams - sequential, communication, activity diagrams.
Static IS design - implementation phase: class diagram and data model design.
Deployment diagrams, components.
Database architectures, SQL, DDL, DCL and TTL. Database structure design - data object, keys, indexes, constraints.
Working with data - SQL query language (data selection, inserting, updating, deleting, grouping, etc.). Views.
Data flow control - cursors, triggers, stored procedures.
Knowledge and expert systems.
Knowledge acquisition.
Knowledge presentation methods.
Heuristic problem solving.
Knowledge systems for risk assessment of production processes.
Genetic algorithms in production control.
Conditions for subject completion
Occurrence in study plans
Occurrence in special blocks
Assessment of instruction