Course detail

Information Systems and Computer Networks

FSI-GIFAcad. year: 2017/2018

Information systems are becoming a more and more important part of the manufacturing systems. Effective work with data and information takes on great importance especially in connection with the conception of the program Industry 4.0.The course is about basic concepts of information theory, students are familiarized with the structure of modern information systems, their design and application in production systems through modern methods of software engineering. The second part of course deals with the hardware and software of computer networks, their importance in the communication subsystem of information systems in production.

Language of instruction

Czech

Number of ECTS credits

6

Mode of study

Not applicable.

Guarantor

doc. Ing. Lubomír Vašek, CSc.

Department

Institute of Production Machines, Systems and Robotics (ÚVSSR)

Learning outcomes of the course unit

Students will be made familiar with the use of IS in manufacturing enterprises, concept of IS, and the methodology for its implementation. Students will acquire theoretical knowledge of and basic practical experience with databases and computer nets.

Prerequisites

Students are expected to have knowledge of:
- basic structure of manufacturing enterprises,
- basic knowledge of information flow in manufacturing processes,
- computer literacy,
- basic knowledge of computer networking.

Co-requisites

Not applicable.

Planned learning activities and teaching methods

The course is taught through lectures explaining the basic principles and theory of the discipline. Exercises are focused on practical topics presented in lectures.
According to the possibility of teaching can be organized lectures for students by practitioners and excursions to companies focused on activities related to the course content.

Assesment methods and criteria linked to learning outcomes

Course-unit credit is conditional on the following:
Participation in practicals and working out of semester work.

Examination: The exam verifies the acquired knowledge and is combined. It has a practical and theoretical part. The practical part examines the student's ability to apply acquired knowledge and methods on practical examples, in the theoretical part knowledge of the theoretical basis.
If a student solves less than half of the examples he has passed, he / she fails.

Course curriculum

Not applicable.

Work placements

Not applicable.

Aims

The aim of the course is to provide students with knowledge of the information flow in a manufacturing enterprise - specify requirements for information handling, methods used to cover these needs, use of information systems. Classification, inner structure and rules for development of IS are also discussed. The emphasis is placed on databases as a fundamental part of IS, as well as the communication in IS trough computer nets.

Specification of controlled education, way of implementation and compensation for absences

Attendance at obligatory lessons is checked and only substantial reasons of absence are accepted. Missed lessons can be substituted for via solution of extra exercises.

Recommended optional programme components

Not applicable.

Prerequisites and corequisites

Not applicable.

Basic literature

Bigelow S.J. Mistrovství v počítačových sítích, Computer Press 2004, ISBN 80-251-0178-9 (CS)
Molnár Z. aj. - Informační systém podniku, skripta UTB Zlín, ISBN 80-238-6525-0 (CS)
OLIVÉ, Antoni. Conceptual modeling of information systems. Berlin: Springer, 2007, xxv, 455 s. ISBN 9783540393894 (EN)
TANENBAUM, Andrew S. Computer networks. 4th ed. New Jersey: Prentice-Hall, c2003, xx, 891 s. ISBN 0-13-066102-3 (EN)

Recommended reading

Bigelow S.J.: Mistrovství v počítačových sítích, Computer Press 2004, ISBN 80-251-0178-9 (CS)
McMillan T. - Cisco Networking Essentials, John Wiley & Sons 2012, ISBN 978-1-118-09759-5 (EN)

Classification of course in study plans

  • Programme M2I-P Master's

    branch M-VSR , 1 year of study, summer semester, compulsory
    branch M-VSR , 1 year of study, summer semester, compulsory

Type of course unit

 

Lecture

26 hod., optionally

Teacher / Lecturer

doc. Ing. Lubomír Vašek, CSc.

Syllabus

1. Lectures contents - systems, information and information systems
2. Keywords definition - quantity of information, transfer of information, codes and coding
3. Information systems and technologies - IS/IT, their role in the digitization of production
4. Structure of IS for a manufacturing enterprises
5. Development of IS for production control - MRP, MRP II, CIM, ERP
6. Life cycle of IS
7. Information strategy for a manufacturing enterprise
8. Data and their processing - database systems, their architecture and types
9. Relation databases
10. Database language SQL
11. Computer networks - basic keywords and terminology
12. Internet and its basic services
13. Modern trends in the use of IS / IT in line with the concept of Industry 4.0

Computer-assisted exercise

13 hod., compulsory

Teacher / Lecturer

Ing. Jiří Kovář, Ph.D.

Syllabus

1-2. Information flow inside production systems
3-4. Information, their quantification and relation to probability
5-6. Database MS Access – basic properties
7-8. SQL – commands for selecting the data (SELECT)
9-10. SQL – commands for data modification (INSERT, UPDATE, etc.)
11-12. Computer networks
13. Evaluation of exercises