Course Unit Code | 352-0521/03 |
---|
Number of ECTS Credits Allocated | 4 ECTS credits |
---|
Type of Course Unit * | Compulsory |
---|
Level of Course Unit * | Second Cycle |
---|
Year of Study * | First Year |
---|
Semester when the Course Unit is delivered | Summer Semester |
---|
Mode of Delivery | Face-to-face |
---|
Language of Instruction | Czech |
---|
Prerequisites and Co-Requisites | Course succeeds to compulsory courses of previous semester |
---|
Name of Lecturer(s) | Personal ID | Name |
---|
| LAN25 | doc. Ing. Lenka Landryová, CSc. |
| SKU52 | Ing. Jolana Škutová, Ph.D. |
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. |
Learning Outcomes of the Course Unit |
---|
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. |
Course Contents |
---|
IS Design - UML (UML standard, language syntax, life cycle).
Analysis of IS requirements, use cases, scenarios.
Dynamic diagrams - sequential, communication, activity diagrams.
Static IS design - implementation phase: class diagram and data model design.
Deployment diagrams, components.
Database architectures, SQL, DDL, DCL and TTL. Database structure design - data object, keys, indexes, constraints.
Working with data - SQL query language (data selection, inserting, updating, deleting, grouping, etc.). Views.
Data flow control - cursors, triggers, stored procedures.
Knowledge and expert systems.
Knowledge acquisition.
Knowledge presentation methods.
Heuristic problem solving.
Knowledge systems for risk assessment of production processes.
Genetic algorithms in production control. |
Recommended or Required Reading |
---|
Required Reading: |
---|
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:
|
Škutová, J. Projektování informačních systémů. Učební text předmětu Informační systémy. Dostupný na URL:
Engineering and Industrial Software Webinars [online], 2020. AVEVA Global: AVEVA [cit. 2020-03-31]. Dostupné z: https://sw.aveva.com/webinars |
Recommended Reading: |
---|
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á. |
HENDERSON, K. Mistrovství v Transact-SQL. Praha : Computer Press, 2000, 496 s. ISBN 80-7226-393-5.
|
Planned learning activities and teaching methods |
---|
Lectures, Tutorials, Project work |
Assesment methods and criteria |
---|
Task Title | Task Type | Maximum Number of Points (Act. for Subtasks) | Minimum Number of Points for Task Passing |
---|
Graded credit | Graded credit | 100 (100) | 51 |
Projekt | Project | 70 | 35 |
Test | Written test | 30 | 15 |