Course Details

Information Technology and System Analysis

Academic Year 2025/26

BUA003 course is part of 1 study plan

​ BPC-SI / E Summer Semester 3rd year

Course Guarantor

doc. RNDr. Jiří Macur, CSc.

Institute

Institute of Computer Aided Engineering and Computer Science

Language of instruction

Czech

Credits

3 credits

Semester

summer

Forms and criteria of assessment

course-unit credit and examination

Offered to foreign students

Not to offer

Course on BUT site

https://www.vut.cz/en/students/courses/detail/289878

Lecture

13 weeks, 2 hours/week, elective

Syllabus

  • 1. Data analysis, E-R diagram, data normalization.
  • 2. Relational calculus, using SQL language, nonSQL systems.
  • 3. Advanced database techniques, indices, database transactions, ACID Rules.
  • 4. Stored procedures and functions in database systems, T-SQL language.
  • 5. Database triggers, constrains, business rules.
  • 6. Features of the mainstream database products: Oracle, MS SQL, MySQL.
  • 7. Basic implementation techniques of information systems.
  • 8. N-layer architecture, middleware, solutions based on Internet, DOTNET, ASP, PHP, Node technology.
  • 9. Process analysis, UML diagrams, BPMN, Data Flow and Status diagram.
  • 10. Life cycle of the system, used development and operation techniques.
  • 11. Access control in application layer, security, risks.
  • 12. Business systems CRM, CMS, ERP. Standardized implementations SAP, MS Dynamics, Oracle.
  • 13. An example of an analysis of a simple information system.

Exercise

13 weeks, 2 hours/week, compulsory

Syllabus

  • 1. Data modeling - knowledge repetition, MS Access database system.
  • 2. SQL query language, SELECT statement.
  • 3. Pivot table in spreadsheet environment.
  • 4. Advanced methods for obtaining information from relational sets - inner and outer join.
  • 5. Methods for relational operations in MS Excel.
  • 6. Elements for manipulating SQL data, DDL, DML subsets.
  • 7. Advanced methods for transactional processing.
  • 8. Advanced tools for process analysis, BPMN diagram design.
  • 9. Status diagram and its implementation in data design.
  • 10. Data Flow diagram, implementation examples.
  • 11.-12. Individual project of a simple information system in MS Access environment.
  • 13. Knowledge testing and defending of IS design.