352-0521/03 – Information Systems (IS)

Gurantor departmentDepartment of Control Systems and InstrumentationCredits4
Subject guarantordoc. Ing. Lenka Landryová, CSc.Subject version guarantordoc. Ing. Lenka Landryová, CSc.
Study levelundergraduate or graduateRequirementCompulsory
Year1Semestersummer
Study languageCzech
Year of introduction2021/2022Year of cancellation
Intended for the facultiesFSIntended for study typesFollow-up Master
Instruction secured by
LoginNameTuitorTeacher giving lectures
LAN25 doc. Ing. Lenka Landryová, CSc.
SKU52 Ing. Jolana Škutová, Ph.D.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Graded credit 2+2
Part-time Graded credit 10+4

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:

ZURAWSKI, R. The Industrial Information Technology Hanbook. Danvers, MA, U.S.A. : CRC Press LLC, 2005. ISBN 0-8493-1985-4. M. Dumas, W.M.P. van der Aalst, and A.H.M. ter Hofstede. Process-Aware Infor- mation Systems: Bridging People and Software through Process Technology. Wiley & Sons, 2005. Dostupný na URL:

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á.

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

Conditions for completion are defined only for particular subject version and form of study

Occurrence in study plans

Academic yearProgrammeField of studySpec.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2021/2022 (N0714A270011) Control of Machines and Processes P Czech Ostrava 1 Compulsory study plan
2021/2022 (N0714A270011) Control of Machines and Processes K Czech Ostrava 1 Compulsory study plan
2020/2021 (N0714A270011) Control of Machines and Processes K Czech Ostrava 1 Compulsory study plan
2020/2021 (N0714A270011) Control of Machines and Processes P Czech Ostrava 1 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner