SubjectsSubjects(version: 889)
Course, academic year 2020/2021
  
Business Data Processing - AB501026
Title: Business Data Processing
Guaranteed by: Department of Economics and Management (837)
Actual: from 2020
Semester: winter
Points: winter s.:6
E-Credits: winter s.:6
Examination process: winter s.:
Hours per week, examination: winter s.:2/2 C+Ex [hours/week]
Capacity: unknown / unknown (unknown)
Min. number of students: unlimited
Language: English
Teaching methods: full-time
Level:  
For type: Bachelor's
Note: course can be enrolled in outside the study plan
enabled for web enrollment
Guarantor: Kaiser Jiří Ing. Ph.D.
Literature -
Last update: Botek Marek Mgr. Ing. Ph.D. (20.01.2020)

R: UNHELKAR, Bhuvan. Software engineering with UML. Boca Raton, [2018]. ISBN 978-1-138-29743-2.

R: Timothy Boronczyk. Jump Start MySQL (1st. ed.). Sitepoint. 2015, ISBN 978-0-9924612-8-7

A: SHERMAN, Rick. Business intelligence guidebook: from data integration to analytics. Amsterdam: Elsevier, Morgan Kaufmann is an imprint of Elsevier, [2015]. ISBN 978-012-4114-616.

A: BHATIA, Parteek. Data mining and data warehousing: principles and practical techniques. Cambridge, United Kingdom: Cambridge University Press, 2019. ISBN 978-1-108-72774-7.

A: MySQL reference manual - http://dev.mysql.com

Syllabus -
Last update: Botek Marek Mgr. Ing. Ph.D. (20.01.2020)

1. Identification of information for specification of requirements on data structure of transaction process systems

2. System states modeling

3. Data modeling using Entity Relationship (E-R) diagram – user preferences modeling

4. Database structure modeling using Entity Relationship (E-R) diagram – platform independent model

5. Database structure modeling using Entity Relationship (E-R) diagram – platform specific model

6. SQL basics for database structure creation (data definition language) a data manipulation in database (data manipulation language)

7. SQL basics for retrieving data from database (data query language) – simple queries

8. SQL basics for retrieving data from database (data query language) – aggregation functions, subselects

9. SQL basics for retrieving data from database (data query language) – joining tables

10. Requirements on management information systems, reporting principles

11. Data structures in management information systems, ETL processes

12. Data mining basics

13. Basic principles of software application development

14. Information security basics

Course completion requirements -
Last update: Kaiser Jiří Ing. Ph.D. (21.09.2020)

seminar works, written exam

 
VŠCHT Praha