352-0521/02 – Information Systems (IS)

Gurantor departmentDepartment of Control Systems and InstrumentationCredits4
Subject guarantordoc. Ing. Lenka Landryová, CSc.Subject version guarantorIng. Jolana Škutová, Ph.D.
Study levelundergraduate or graduateRequirementCompulsory
Year1Semestersummer
Study languageCzech
Year of introduction2010/2011Year 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

E-learning

Other requirements

A student will submit his/her project documentation.

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

1. Principles of information systems design based on UML. Basic concepts, software support. Life cycle of information systems design. 2. Requirements analysis in system and information engineering - creating functional and non-functional requirements, syntax, priority, status. 3. Identification of use cases – analysis of actors, use cases, scenarios a input/output constraints, relations. 4. Modeling of project's dynamic phase – sequence/communication diagrams, activity diagrams. 5. The static view of an information system - conceptual, design and implementation stages of the static model, the basic elements of the model class / data model. 6. Implementation phase of information systems design – component diagrams and deployment diagrams. 7. Testing of information system, process verification and validation, software deployment, documentation composition and generating of installation materials. 8. Installing and configuration of SQL Server, databases and files management, database tools, SQL, transaction processing. 9. Creating a database - the data object, data types, keys, indexes, constraints. 10. Data manipulation - the SQL query language, fundamentals queries, joins, grouping, views. 11. Flow control - stored procedures, cursors, triggers. 12. Fundamentals of ASP.NET design – configuration of database connection, Grid View, Data View, data security.

Conditions for subject completion

Part-time form (validity from: 2010/2011 Summer semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of pointsMax. počet pokusů
Graded exercises evaluation Graded credit 100 (100) 51 3
        Test Written test 30  15
        Projekt Project 70  30
Mandatory attendence participation: Mandatory participation in classes according to the combined study schedule. To complete the credit, students must submit the project and successfully pass the credit test.

Show history

Conditions for subject completion and attendance at the exercises within ISP: I order to complete the credit, students submit and defend a set of solved examples assigned by the teacher and submit the program files for the solved examples, if they are required for a specific example. On the basis of a successfully completed credit, they can take an exam, which will consist of a practical and a theoretical part and on time during the exam period.

Show history

Occurrence in study plans

Academic yearProgrammeBranch/spec.Spec.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2022/2023 (N2301) Mechanical Engineering (3902T004) Automatic Control and Engineering Informatics P Czech Ostrava 1 Compulsory study plan
2022/2023 (N2301) Mechanical Engineering (3902T004) Automatic Control and Engineering Informatics K Czech Ostrava 1 Compulsory study plan
2021/2022 (N2301) Mechanical Engineering (3902T004) Automatic Control and Engineering Informatics P Czech Ostrava 1 Compulsory study plan
2021/2022 (N2301) Mechanical Engineering (3902T004) Automatic Control and Engineering Informatics K Czech Ostrava 1 Compulsory study plan
2020/2021 (N2301) Mechanical Engineering (3902T004) Automatic Control and Engineering Informatics P Czech Ostrava 1 Compulsory study plan
2020/2021 (N2301) Mechanical Engineering (3902T004) Automatic Control and Engineering Informatics K Czech Ostrava 1 Compulsory study plan
2019/2020 (N2301) Mechanical Engineering (3902T004) Automatic Control and Engineering Informatics P Czech Ostrava 1 Compulsory study plan
2019/2020 (N2301) Mechanical Engineering (3902T004) Automatic Control and Engineering Informatics K Czech Ostrava 1 Compulsory study plan
2018/2019 (N2301) Mechanical Engineering (3902T004) Automatic Control and Engineering Informatics P Czech Ostrava 1 Compulsory study plan
2018/2019 (N2301) Mechanical Engineering (3902T004) Automatic Control and Engineering Informatics K Czech Ostrava 1 Compulsory study plan
2017/2018 (N2301) Mechanical Engineering (3902T004) Automatic Control and Engineering Informatics P Czech Ostrava 1 Compulsory study plan
2017/2018 (N2301) Mechanical Engineering (3902T004) Automatic Control and Engineering Informatics K Czech Ostrava 1 Compulsory study plan
2016/2017 (N2301) Mechanical Engineering (3902T004) Automatic Control and Engineering Informatics P Czech Ostrava 1 Compulsory study plan
2016/2017 (N2301) Mechanical Engineering (3902T004) Automatic Control and Engineering Informatics K Czech Ostrava 1 Compulsory study plan
2015/2016 (N2301) Mechanical Engineering (3902T004) Automatic Control and Engineering Informatics P Czech Ostrava 1 Compulsory study plan
2015/2016 (N2301) Mechanical Engineering (3902T004) Automatic Control and Engineering Informatics K Czech Ostrava 1 Compulsory study plan
2014/2015 (N2301) Mechanical Engineering (3902T004) Automatic Control and Engineering Informatics K Czech Ostrava 1 Compulsory study plan
2014/2015 (N2301) Mechanical Engineering (3902T004) Automatic Control and Engineering Informatics P Czech Ostrava 1 Compulsory study plan
2013/2014 (N2301) Mechanical Engineering (3902T004) Automatic Control and Engineering Informatics P Czech Ostrava 1 Compulsory study plan
2013/2014 (N2301) Mechanical Engineering (3902T004) Automatic Control and Engineering Informatics K Czech Ostrava 1 Compulsory study plan
2012/2013 (N2301) Mechanical Engineering (3902T004) Automatic Control and Engineering Informatics K Czech Ostrava 1 Compulsory study plan
2012/2013 (N2301) Mechanical Engineering (3902T004) Automatic Control and Engineering Informatics P Czech Ostrava 1 Compulsory study plan
2011/2012 (N2301) Mechanical Engineering (3902T004) Automatic Control and Engineering Informatics P Czech Ostrava 1 Compulsory study plan
2011/2012 (N2301) Mechanical Engineering (3902T004) Automatic Control and Engineering Informatics K Czech Ostrava 1 Compulsory study plan
2010/2011 (N2301) Mechanical Engineering (3902T004) Automatic Control and Engineering Informatics P Czech Ostrava 1 Compulsory study plan
2010/2011 (N2301) Mechanical Engineering (3902T004) Automatic Control and Engineering Informatics K Czech Ostrava 1 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner

Assessment of instruction



2020/2021 Summer
2019/2020 Summer
2016/2017 Summer
2015/2016 Summer
2013/2014 Summer
2012/2013 Summer
2011/2012 Summer