ESF:BKM_DATS Database systems - Course Information
BKM_DATS Database systems
Faculty of Economics and AdministrationAutumn 2022
- Extent and Intensity
- 0/0/0. 6 credit(s). Type of Completion: zk (examination).
- Teacher(s)
- doc. RNDr. Vlastislav Dohnal, Ph.D. (lecturer)
- Guaranteed by
- doc. RNDr. Vlastislav Dohnal, Ph.D.
Department of Applied Mathematics and Computer Science – Faculty of Economics and Administration
Contact Person: Lenka Hráčková
Supplier department: Department of Machine Learning and Data Processing – Faculty of Informatics - Timetable
- Fri 21. 10. 12:00–15:50 VT202, Fri 11. 11. 12:00–15:50 VT202, Fri 9. 12. 16:00–19:50 VT202
- Course Enrolment Limitations
- The course is only offered to the students of the study fields the course is directly associated with.
- fields of study / plans the course is directly associated with
- Business Analytics (programme ESF, B-BA)
- Course objectives
- Understanding of database technologies, ability to specify key parts of database design, normalize database schema, formulate SQL queries.
- Learning outcomes
- - explain the basic concepts used in database technology;
- specify the key parts of the database design;
- normalize the database schema and understand normal forms;
- know the syntax and semantics of the main SQL statements;
- explain different ways of joining tables. - Syllabus
- 1) Theoretical introduction to database systems * basic concepts, database models; * relational algebra, data model normalization; * data model design principles.
- 2. Installation and configuration of database server * basics of configuration; * basics of creating database applications in the WWW environment; * ensuring data integrity; * ensuring data security.
- 3. Introduction to SQL * storage configuration; * built-in functions (mathematical, text, date); * aggregate function.
- 4. Principles of architecture and database design; * conceptual, logical and physical model; * ER diagram syntax, relationship definition and relationship cardinality; * data warehousing.
- 5. Demonstration of database design on a simple example * solve typical problems; * realization of N: N binding.
- 6. Normalization of data base * normal forms and their meaning.
- 7. Creation of simple application logic in database * Database triggers and procedures, nested SELECT queries.
- 8. Cooperation with the external environment * Data export.
- Literature
- recommended literature
- SILBERSCHATZ, Abraham, Henry F. KORTH and S. SUDARSHAN. Database system concepts. 6th ed. Boston: McGraw-Hill, 2011, xxvi, 1139. ISBN 9780073523323. info
- Teaching methods
- Practically oriented tutorials with an emphasis on the active students' approach. Study of recommended literature, autokorection tests, individual work on assigned tasks.
- Assessment methods
- Tests and project
- Language of instruction
- Czech
- Further comments (probably available only in Czech)
- Study Materials
The course is taught annually.
Information on the extent and intensity of the course: tutorial 12 hodin.
- Enrolment Statistics (Autumn 2022, recent)
- Permalink: https://is.muni.cz/course/econ/autumn2022/BKM_DATS