Course detail

Information Systems and Computer Networks

FSI-GIFAcad. year: 2016/2017

Information systems are becoming a more and more important part of the manufacturing systems. The course has two parts. The first part is focused on the basics of the theory of information, coding of messages and the basics of information transfer. The second part deals with the structure of modern information systems, their design and application in the manufacturing and production systems. It includes practical examples from the industry. The students also learn about the technical part of IS - computer nets.

Language of instruction

Czech

Number of ECTS credits

5

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 has a practical and a theoretical part. In the practical part student solves simple database problem. Successful solving at least half of the problems in the practical part is necessary. The theoretical (oral) part tests student’s knowledge.

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-KSB , 1 year of study, summer semester, compulsory-optional
    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
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. Using the network technology in industrial practice

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