Course detail

Information Systems and Computer Networks

FSI-GIF Acad. year: 2027/2028 Summer semester

Information systems currently form a very important part of production systems. Effective work with data and information is gaining importance, particularly in connection with the Industry 4.0 programme concept.

The course covers the basic concepts of information theory and the principles of data coding, compression and encryption. Students become familiar with the structure of modern information systems, with relational databases and the SQL language as a means of querying and modifying data, and with the design and deployment of information systems in the field of production systems.

Students are further familiarised with the means of computer networks, with their importance in the communication subsystem of information systems in production, and with the basic security risks of industrial networks. Attention is also paid to production management systems of the MRP, MRP II, CIM and ERP types and to the use of the Internet of Things and cloud systems in industry.

Language of instruction

Czech

Number of ECTS credits

4

Entry knowledge

The student is able to describe the principle of binary data representation and the basic data types. The student is able to work with an operating system at the level of file management and application installation, and with a spreadsheet application at the level of calculations, filters and charts.

The student is able to explain the concept of a computer network, to distinguish between a local area network and a wide area network, and to describe the principle of data transmission over a network at user level, including the fundamentals of IP network addressing.

Rules for evaluation and completion of the course

The course is completed by a course credit and an examination.

Course credit requirements

Compulsory attendance at computer-aided exercises. Tolerance of one excused absence; the method of making up for missed instruction shall be determined by the teacher.

Continuous fulfilment of tasks in the exercises: database tasks in MS Access, SQL queries, creation of a web page, and a task from the field of the Internet of Things and cloud systems.

Elaboration of a semester project in the range of 10 to 15 standard pages, focused on the design of an information subsystem of a manufacturing enterprise, comprising a data model, a set of SQL queries and a description of the network solution. The project shall be submitted no later than in the 12th teaching week and shall be defended in the 12th teaching week.

A maximum of 0 to 15 points may be awarded for the continuous tasks and 0 to 15 points for the semester project and its defence, i.e. 0 to 30 points in total.

The course credit is awarded upon fulfilment of the attendance requirement; the score achieved may be as low as 0 points. The course credit is awarded in the 13th teaching week; the content of the 13th teaching week is the verification of the results of the exercises and the award of the course credit.

Examination

The examination takes the form of a written test covering the areas of databases and the SQL language, computer networks, and information systems in production. A maximum of 0 to 70 points may be obtained from the test.

Only a student who has been awarded the course credit may sit the examination.

Final classification

The overall assessment consists of the points from the exercises (0 to 30 points) and the points from the examination (0 to 70 points), i.e. 100 points at most.

Classification scale: A 90 to 100 points, B 80 to 89 points, C 70 to 79 points, D 60 to 69 points, E 50 to 59 points, F 0 to 49 points.

Aims

The graduate is able to:

  • explain the concepts of information, entropy and redundancy and the principles of data coding, compression and encryption,
  • design a relational data model for an assigned area of a manufacturing enterprise and to bring it into the third normal form,
  • construct SQL queries for data selection, aggregation and modification, and to explain the difference between the data definition language and the data manipulation language,
  • describe the architecture of an information system of a manufacturing enterprise and to classify within it ERP and MES systems and a maintenance management system,
  • explain the principle of data transmission in a computer network, addressing and basic network services, and to identify the basic security risks of an industrial network,
  • put into operation a simple database application with a web interface over an assigned data source.

The study programmes with the given course

Programme N-VSR-P: Production Machines, Systems and Robots, Master's, compulsory-optional

Type of course unit

 

Lecture

13 hours, optionally

Syllabus

1. – 2. Course contents – systems, information, information size, information transfer, codes, and coding
3. – 4. Data and its processing in IS – database systems, their types, and architecture, relational databases
5. – 6. SQL as an example of database language
7. – 8. Computer networks – basic terms and terminology, Internet and its basic services
9. – 10. Information strategy in manufacturing company
11. – 12. IS structure of the manufacturing company, IS for production management – MRP, MRPII, CIM, ERP
13. Credit

Computer-assisted exercise

26 hours, compulsory

Syllabus

1. Working with data, data compression and data encryption
2. MS Access database, tables and query creation
3. MS Access database, relational database
4. SQL – statements for data selection and presentation
5. SQL – data modification commands, external access to DS
6. SQL – data modification commands, external access to DS
7. IoT and cloud systems – basic information
8. IoT and cloud systems – practical examples
9. Computer networks, Internet and its basic services
10. Web page creation – static, dynamic
11. Creating web pages – dynamic
12. Completion of final protocols
13. Credit