Course detail

Information technology and system analysis

FAST-BU04Acad. year: 2013/2014

Modern database systems, DBMS architecture and the role in information systems. Actual technologies for information systems design, n-tiers architecture. Life cycle and information system implementation. Process analysis and management. Modelling tools of the system analysis. The support of information technologies on particular levels of management. Economy of IS creation.
Practical education is focused on the exercising of analytic skills in the case of the suggestion of the information system of the solved subject including the basic implementation techniques.

Language of instruction

Czech

Number of ECTS credits

4

Mode of study

Not applicable.

Guarantor

doc. RNDr. Jiří Macur, CSc.

Department

Institute of Computer Aided Engineering and Computer Science (AIU)

Learning outcomes of the course unit

Students will obtain ability to perform the data modeling analyzes with using standard diagrams and methods. They will also acquire the basic skills to perform process analysis and understand the kernel and importance of process management. After completing the course they will be able to work in all phases of design and implementation of information system. Graduates will understand the modern database technologies that are currently used at all levels of management. Graduates will gain the ability to use non-standard data warehousing and multi-criteria assessment of the information system in terms of technology, cost and efficiency.

Prerequisites

Basic software tools for data management and processing, basics of enterprise economics, basics of project management, methods of relational data models design.

Co-requisites

Not applicable.

Planned learning activities and teaching methods

The course is taught through lectures, practical classes and self-study assignments. Attendance at lectures is optional, but attendance at classes is compulsory.

Assesment methods and criteria linked to learning outcomes

Active participation in the exercises - 20%. Individual project of analysis and design of a simple information system - 30 %. Test of theoretical knowledge in the field of data processing and analysis, and field of information technology systems - 50%.

Course curriculum

1. System accession and information
2. Information technology – at present and trends
3. Program tools
4. Data processing
5. Database systems
6. Modelling tools of the system analysis – data area
7. Modelling tools of the system analysis – functional area
8. Architecture IS/IT – levels of the management
9. Architecture IS/IT – particular dimensions
10. Enterprise Resources Planning
11. Information system development
12. Technical tools
13. Communication tools. TCO and the efficiency of information systems

Work placements

Not applicable.

Aims

To get general orientation in information technologies and possibilities of their use at firm’s management. To learn basic tools of system analysis. To acquire skills and ability to model reality during formation of information system.

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

Extent and forms are specified by guarantor’s regulation updated for every academic year.

Recommended optional programme components

Not applicable.

Prerequisites and corequisites

Not applicable.

Basic literature

Bruckner, Tomáš a kol.: Tvorba informačních systémů. Grada Publishing, 2012. ISBN 978-80-247-4153-6. (CS)

Recommended reading

Řepa, Václav: Podnikové procesy – procesní řízení a modelování. Grada Publishing, 2005. ISBN 80-247-1281-4. (CS)
Sodomka, Petr: Informační systémy v podnikové praxi. Computer Press, 2006. (CS)
Řepa, Václav: Procesně řízená organizace. Grada Publishing, 2012. ISBN 978-80-247-4128-4. (CS)

Classification of course in study plans

  • Programme B-P-C-MI Bachelor's

    branch MI , 1. year of study, summer semester, compulsory

  • Programme B-P-E-SI Bachelor's

    branch E , 4. year of study, summer semester, compulsory

  • Programme B-P-C-SI Bachelor's

    branch E , 4. year of study, summer semester, compulsory

  • Programme B-K-C-SI Bachelor's

    branch E , 4. year of study, summer semester, compulsory

Type of course unit

 

Lecture

26 hours, optionally

Teacher / Lecturer

doc. RNDr. Jiří Macur, CSc.

Syllabus

1. Architecture of information systems, middleware
2. Information systems hosting platforms
3. Most popular modern DBMS systems: Oracle, MS SQL, MySQL
4. Internet solutions, .NET, ASP, PHP technologies
5. Advanced db techniques, database transactions, ACID rules
6. Stored procedures and functions, Transact-SQL language
7. Triggers, constrains, business rules
8. 3-tiers architecture
9-11. Information system inplementation on network platform
12. Access control in application layer
13. Example of analysis of simple information system

Exercise

26 hours, compulsory

Teacher / Lecturer

doc. RNDr. Jiří Macur, CSc.

Syllabus

1. Data modeling - repetition.
2.-3. Query language for mining of data warehouse, the SELECT statement in the SQL language, pivot table in spreadsheet environment.
4. Advanced procedures for obtaining information from relational sets - internal, left and right, outer joins.
5. Methods for relational operations in MS Excel.
6. Elements for data manipulation in SQL.
7. Advanced procedures for transaction processing.
8.-9. Process analysis, design of BPMN diagram.
10. The state diagram and its implementation in the data model.
11.-12. Individual project of simple information system.
13. Testing of knowledge and advocacy of design of IS.