Course detail
Information Systems and Computer Networks
FSI-GIF-KAcad. year: 2023/2024
Information systems are nowadays a very important part of production systems. Effective work with data and information is of particular importance in connection with the concept of Industry 4.0. In this course, basic concepts of information theory are discussed, students are familiar with the structure of modern information systems, their design and deployment in the field of manufacturing systems through the latest methods of software engineering. Students are also acquainted with the means of computer networks, their importance in the communication subsystem of information systems in production.
Language of instruction
Number of ECTS credits
Mode of study
Guarantor
Entry knowledge
Rules for evaluation and completion of the course
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.
Aims
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.
Study aids
Prerequisites and corequisites
Basic literature
Ošmera P. - Informační systémy, skripta VUT
Recommended reading
Classification of course in study plans
- Programme N-VSR-K Master's 1 year of study, summer semester, compulsory-optional
Type of course unit
Guided consultation in combined form of studies
Teacher / Lecturer
Syllabus
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
Guided consultation
Teacher / Lecturer
Syllabus
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