BKM_DATS Database systems

Faculty of Economics and Administration
Autumn 2024
Extent and Intensity
0/0/0. 6 credit(s). Type of Completion: zk (examination).
In-person direct teaching
Teacher(s)
RNDr. Matej Antol, Ph.D. (lecturer)
doc. RNDr. Vlastislav Dohnal, Ph.D. (lecturer)
Guaranteed by
doc. RNDr. Vlastislav Dohnal, Ph.D.
Division 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
Sat 5. 10. 16:00–19:50 VT206, Sat 2. 11. 16:00–19:50 VT204, Fri 13. 12. 16:00–19:50 VT204
Prerequisites
FORMA(K)
Knowledge of basic SQL commands (SELECT, CREATE TABLE).
Course Enrolment Limitations
The course is only offered to the students of the study fields the course is directly associated with.

The capacity limit for the course is 26 student(s).
Current registration and enrolment status: enrolled: 20/26, only registered: 0/26
fields of study / plans the course is directly associated with
Course objectives
Understanding of database technologies, ability to specify key parts of database design, normalize database schema, formulate advanced SQL queries.
Learning outcomes
- explain basic terms used in database technologies;
- specify the key parts of the database design;
- design and normalize database schema, understand normal forms;
- know the syntax and semantics of the main commands of the SQL language;
- explain the principle of query optimization and schema changes to increase performance.
Syllabus
  • 1. Theoretical introduction to database systems * basic concepts, database models; * relational algebra, data model normalization, normal forms; * data model design principles.
  • 2. Principles of architecture and database design; * conceptual, logical and physical model; * ER diagram syntax, relationship definition and relationship cardinality; * data warehousing.
  • 3. Database design in examples * solve typical problems; * realization of N:N binding; * normalization.
  • 4. Advanced SQL * built-in functions (mathematical, text, date); * aggregate function, windowing functions; * analytic queries.
  • 5. Creation of simple application logic in database * Database triggers and procedures, nested SELECT queries;
  • 6. Query and Transaction Processing * Query evaluation and optimization; * Indexing; * Transaction processing.
  • 7. Cooperation with the external environment * Data import and 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
Homework; written exam and oral interview.
Language of instruction
Czech
Study support
https://is.muni.cz/auth/el/econ/podzim2024/BKM_DATS/index.qwarp
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.
The course is also listed under the following terms Autumn 2022, Autumn 2023.
  • Enrolment Statistics (recent)
  • Permalink: https://is.muni.cz/course/econ/autumn2024/BKM_DATS