Course Details

Information Technology and System Analysis

Academic Year 2024/25

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.