|
Lecturer(s)
|
-
Kubát David, Ing. Ph.D., Ing.Paed.IGIP
-
Nejedlová Dana, Ing. Ph.D.
|
|
Course content
|
Lectures (topics): 1. Databases: basic objects, tables, relationships, referential integrity. 2. Databases: M relationships, database management and analysis, data import and linking. 3. Databases: queries. 4. Databases: forms and reports. 5. Business intelligence - introduction, definitions, and key concepts. 6. Business intelligence - data types and sources, the ETL process. 7. Artificial intelligence - models, principles, ethics, and prompting. Seminars (topics): 1. Databases: relationships. 2. Databases: tables and simple queries. 3. Databases: advanced queries. 4. Databases: forms and reports. 5. Test. 6. Business intelligence - working with a simple dataset, data cleaning. 7. Business intelligence - creating a first simple report, working with filters and trends. 8. Business intelligence - analysis of a prepared dataset, simulation of a business decision based on a report. 9. Artificial intelligence - prompting. 10. Artificial intelligence - working with graphics. 11. Project work. 12. Test.
|
|
Learning activities and teaching methods
|
|
unspecified
|
|
Learning outcomes
|
The aim of the subject is to introduce students to the database system MS Access and its applications in corporate management - databases, relations, referential integrity, tables, queries, forms, sub forms, graphs, macros, modules, compatibility with other programmes, outputs to the Internet and Intranet, and Visual Basic language.
|
|
Prerequisites
|
unspecified
|
|
Assessment methods and criteria
|
unspecified
|
|
Recommended literature
|
|