Course: Databases and Database Systems for Education

« Back
Course title Databases and Database Systems for Education
Course code KVD/DDS
Organizational form of instruction Lecture + Seminary
Level of course Bachelor
Year of study 2
Semester Summer
Number of ECTS credits 3
Language of instruction Czech
Status of course Compulsory
Form of instruction Face-to-face
Work placements This is not an internship
Recommended optional programme components None
Lecturer(s)
  • Grolmus Petr, Ing.
  • Michalík Petr, Ing. Ph.D.
  • Mainz Denis, PhDr. Ph.D.
  • Toman Jiří, Dr. Ing.
Course content
Subject curriculum: - notions from the field of databases and database management systems, database models, - relational database, importance, rules and principles applied to the design and management, software tools for data modeling ERM (ERD), - database objects, their importance and application in a relational database, - tables in the context of relational databases, data import and export, - queries, their types and usage in data organization and data management in relational database, - forms in the context of relational databases, form components, their formatting and properties, - reports and presentation of relational database data content, - working with external databases in the chosen database system, data import and export, - database security, authenticated access, sharing and multi-user access to the database, - exemplary tasks and didactic principles for teaching of databases and database systems, - programming in databases by using of software tools according to the current needs of school practice.

Learning activities and teaching methods
Lecture with practical applications, E-learning, Cooperative instruction, Instruction based on dialogue, Skills demonstration, Task-based study method, Individual study, Lecture, Lecture with visual aids, Seminar
  • Preparation for comprehensive test (10-40) - 10 hours per semester
  • Presentation preparation (report) (1-10) - 5 hours per semester
  • Preparation for formative assessments (2-20) - 5 hours per semester
  • Undergraduate study programme term essay (20-40) - 20 hours per semester
  • Contact hours - 39 hours per semester
prerequisite
professional knowledge
Basic input knowledge with computer and Windows application.
professional skills
Basic input skills with computer and Windows application.
learning outcomes
professional knowledge
znát postupy využívané při návrhu, tvorbě a správě relační databáze
pochopit principy a zásady uplatňované při práci s databázovým systémem
professional skills
umět aplikovat postupy využívané při návrhu, tvorbě a správě relační databáze s využitím vhodně zvolených programových nástrojů
umět demonstrovat postupy využívané při návrhu, tvorbě a správě relační databáze s využitím vhodně zvolených programových nástrojů s ohledem na vzdělávání
general eligibility
N/A
teaching methods
professional knowledge
Lecture
Lecture with visual aids
Seminar
E-learning
Task-based study method
Cooperative instruction
Individual study
Instruction based on dialogue
Lecture with practical applications
professional skills
Task-based study method
Skills demonstration
Cooperative instruction
Seminar
Individual study
general eligibility
Individual study
Students' self-study
assessment methods
professional knowledge
Test
Seminar work
Continuous assessment
Individual presentation at a seminar
professional skills
Skills demonstration during seminar
Test
Continuous assessment
Seminar work
general eligibility
Continuous assessment
Seminar work
Recommended literature
  • Belko, Peter. Microsoft Access 2013 : podrobná uživatelská příručka. 1. vyd. Brno : Computer Press, 2014. ISBN 978-80-251-4125-0.
  • Hernandez, Michael J. Návrh databází. 1. vyd. Praha : Grada, 2006. ISBN 80-247-0900-7.
  • Kaluža, Jindřich; Kalužová, Ludmila. Modelování dat v informačních systémech. 1. vyd. Praha : Ekopress, 2012. ISBN 978-80-86929-81-1.
  • Kopeček, Pavel. Příklad v MS Access. [Plzeň] : SmartMotion, 2013. ISBN 978-80-87539-51-4.
  • Kroenke, David; Auer, David J. Databáze. 1. vydání. 2015. ISBN 978-80-251-4352-0.
  • Lacko, Ľuboslav; Eder, Tomáš. SQL : hotová řešení. Vyd. 1. Brno : Computer Press, 2003. ISBN 80-7226-975-5.
  • Písek, Slavoj. Access 2010: podrobný průvodce. Praha: Grada, 2011. ISBN 978-80-247-3653-2.
  • Pokorný, Jaroslav; Valenta, Michal. Databázové systémy. 1. vydání. 2013. ISBN 978-80-01-05212-9.
  • Stanek, William R. Microsoft SQL Server 2012 : kapesní rádce administrátora. 1. vyd. Brno : Computer Press, 2013. ISBN 978-80-251-3797-0.


Study plans that include the course
Faculty Study plan (Version) Branch of study Category Recommended year of study Recommended semester
Faculty of Education Biology in Education (16) Biology courses 2 Summer
Faculty of Education Physics in Education (16) Physics courses 2 Summer
Faculty of Education Chemistry in Education (17) Chemistry courses 2 Summer
Faculty of Education - (17) Pedagogy, teacher training and social care 2 Summer
Faculty of Education Physical Education in Education (16) Physical education and sport 2 Summer
Faculty of Education Information Technologies in Education (17) Informatics courses 2 Summer
Faculty of Education Chemistry in Education (16) Chemistry courses 2 Summer
Faculty of Education - (16) Pedagogy, teacher training and social care 2 Summer
Faculty of Education Studies in Mathematics (17) Mathematics courses 2 Summer
Faculty of Education Physics in Education (17) Physics courses 2 Summer
Faculty of Education Geography in Education (16) Pedagogy, teacher training and social care 2 Summer
Faculty of Education Information Technologies in Education (16) Informatics courses 2 Summer
Faculty of Education Information Technologies in Education (17) Informatics courses 2 Summer
Faculty of Education Russian Language in Education (17) Pedagogy, teacher training and social care 2 Summer
Faculty of Education Studies in Mathematics (16) Mathematics courses 2 Summer
Faculty of Education Geography in Education (17) Pedagogy, teacher training and social care 2 Summer
Faculty of Education Biology in Education (17) Biology courses 2 Summer
Faculty of Education English Language in Education (17) Pedagogy, teacher training and social care 2 Summer
Faculty of Education History in Education (17) History courses 2 Summer
Faculty of Education Physical Education in Education (17) Physical education and sport 2 Summer