Course: Database Systems 2

« Back
Course title Database Systems 2
Course code KMI/KDBS2
Organizational form of instruction Lecture
Level of course Bachelor
Year of study not specified
Semester Summer
Number of ECTS credits 3
Language of instruction Czech
Status of course Optional
Form of instruction Face-to-face
Work placements This is not an internship
Recommended optional programme components None
  • Remeš Radim, Mgr.
  • Beránek Ladislav, doc. Ing. CSc.
Course content
1. - Introduction into data mining 2. - Data sources. Relational DB. OLAP. Data warehouses. 3. - Fundamentals of statistics and 4. - Statistics. Pivot tables. Regression analyzes. Clustering. 5. - Data preparing 6. - Machine learning. 7. - Decision trees. 8. - Association rules. 9. - Decision rules. 10. - Neural networks, Bayesian classification. 11. - Result evaluation. 12. - Data mining software systems overview.

Learning activities and teaching methods
Monologic (reading, lecture, briefing), Demonstration, E-learning
  • Class attendance - 8 hours per semester
  • Preparation for classes - 32 hours per semester
  • Preparation for credit - 20 hours per semester
  • Semestral paper - 24 hours per semester
Learning outcomes
The course is based on practical programming of database applications - creating of database models and connection of relational databases with object-oriented programs. Students are introduced to procedures of analysis, modeling and implementation of complex projects based on manipulation with data.
Student will be familiarized with the steps of the knowledge discovery process, and with techniques, algorithms and tools used in the process od knowledge discovery in databases. Student will be able to solve simple practical data mining tasks.
The subject Database systems 1 (DBS1)
----- or -----
----- or -----
----- or -----

Assessment methods and criteria
Student performance assessment, Test, Seminar work

Credit Requirements: Programming partial short tasks, creating a project application. Global success rate minimally 65%.
Recommended literature
  • CONOLLY, T., BEGG, C., HOLOWCZAK, R. Mistrovství - Databáze. Computer Press, 2009.
  • Hernandez, M., J. Návrh databází.. Grada, 2006. ISBN 80-247-0900-7.
  • Kroenke David M. Databáze. Praha: Computer Press, 2015. ISBN 978-80-251-4352-0.
  • SHOEMAKER, M., L. UML Applied: A .NET Perspective. Apress, 2004.
  • THOMSEN, C. Database Programming with C#. Apress, 2002.

Study plans that include the course
Faculty Study plan (Version) Category of Branch/Specialization Recommended year of study Recommended semester
Faculty: Faculty of Economics Study plan (Version): Economic Informatics (4) Category: Economy 2 Recommended year of study:2, Recommended semester: Summer