Course detail
Information technology and system analysis
FAST-BU04Acad. year: 2014/2015
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
Number of ECTS credits
Mode of study
Guarantor
Department
Learning outcomes of the course unit
Prerequisites
Co-requisites
Planned learning activities and teaching methods
Assesment methods and criteria linked to learning outcomes
Course curriculum
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
Work placements
Aims
Specification of controlled education, way of implementation and compensation for absences
Recommended optional programme components
Prerequisites and corequisites
Basic literature
Recommended reading
Řepa, Václav: Procesně řízená organizace. Grada Publishing, 2012. ISBN 978-80-247-4128-4. (CS)
Sodomka, Petr: Informační systémy v podnikové praxi. Computer Press, 2006. (CS)
Classification of course in study plans
Type of course unit
Lecture
Teacher / Lecturer
Syllabus
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
Teacher / Lecturer
Syllabus
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.