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
Institute
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
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.