BKM_DATS Database systems

Faculty of Economics and Administration
Autumn 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
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.
The course is also listed under the following terms Autumn 2023, Autumn 2024.
  • Enrolment Statistics (Autumn 2022, recent)
  • Permalink: https://is.muni.cz/course/econ/autumn2022/BKM_DATS