University of West Bohemia
Study programmes & Course catalogue
for academic year 2024/2025
University of West Bohemia
Česky
Search
FAQ

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 not specified
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)
  • Zíka Miroslav, Mgr.
  • Bezděka Jan, Mgr.
  • Baťko Jan, Mgr. Ph.D.
Course content
- Entity-relational databases, their principles, rules and principles used in designing and managing. - Database concepts, Entity-relationship model (ERM), drawing convention (Entity-relationship diagram), data modeling. - Data types used in databases, benefits and disadvantages of their use. - Database objects, their meaning and application in a relational database. - Tables in the relational database context, importance and use of primary and foreign keys, data types and relations, data import and export. - Queries, their types and uses for organizing and managing data in a relational database, query criteria and rules associated with writing them. - Types of database functions, ways of writing and possibilities of their application. - Interactive forms and reports in a local entity-relational database. Features and use of components in form and database assembly. - Database systems, their availability and their use in the private and public business sphere, government and school facilities. - Database security, authenticated access, sharing, and multi-user access to the database. - Database language, its syntax and examples of use with respect to the selected database system. - Ability to write and present data content of a relational database on the public network. - Typical tasks and didactic principles in the teaching of databases and database systems in the context of selected thematic units of the curriculum.

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
Knowledge
Basic input knowledge with computer and Windows application.
Skills
Basic input skills with computer and Windows application.
Competences
N/A
learning outcomes
Knowledge
know the procedures used in the design, creation and management of a relational database
understand the principles and principles applied when working with a database system
Skills
be able to apply the procedures used in the design, creation and management of a relational database using appropriately selected software tools
be able to demonstrate the procedures used in the design, creation and management of a relational database using appropriately selected software tools with regard to education
Competences
N/A
teaching methods
Knowledge
Lecture
Lecture with visual aids
Seminar
E-learning
Task-based study method
Cooperative instruction
Individual study
Discussion
Interactive lecture
Skills
Individual study
Task-based study method
Skills demonstration
Cooperative instruction
Seminar
Competences
Self-study of literature
Individual study
Task-based study method
assessment methods
Knowledge
Test
Seminar work
Continuous assessment
Individual presentation at a seminar
Skills
Skills demonstration during practicum
Test
Seminar work
Continuous assessment
Competences
Continuous assessment
Seminar work
Skills demonstration during practicum
Recommended literature
  • CONOLLY, Thomas, Carolyn E. BEGG a Richard HOLOWCZAK. Mistrovství - databáze: profesionální průvodce tvorbou efektivních databází. Brno: Computer Press. 2009.
  • 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.
  • Kroenke, David; Auer, David J. Databáze. 1. vydání. 2015. ISBN 978-80-251-4352-0.
  • Laurenčík, Marek. SQL: podrobný průvodce uživatele. Praha. 2018.
  • Pokorný Jaroslav, Valenta, Michal. Databázové systémy. 2. přepracované vydání. Praha, Česká technika - nakladatelství ČVUT. 2020.
  • Vystavěl, Radek. Databáze a SQL pro začátečníky. Ondřejov: Radek Vystavěl. 2021.


Study plans that include the course
Faculty Study plan (Version) Category of Branch/Specialization Recommended year of study Recommended semester
Faculty: Faculty of Education Study plan (Version): Information Technologies in Education (19) Category: Informatics courses 2 Recommended year of study:2, Recommended semester: Summer
Faculty: Faculty of Education Study plan (Version): Information Technologies in Education (16) Category: Informatics courses 2 Recommended year of study:2, Recommended semester: Summer
Faculty: Faculty of Education Study plan (Version): Geography in Education (19) Category: Pedagogy, teacher training and social care 2 Recommended year of study:2, Recommended semester: Summer
Faculty: Faculty of Education Study plan (Version): Geography in Education (18) Category: Pedagogy, teacher training and social care 2 Recommended year of study:2, Recommended semester: Summer
Faculty: Faculty of Education Study plan (Version): Physics in Education (16) Category: Physics courses 2 Recommended year of study:2, Recommended semester: Summer
Faculty: Faculty of Education Study plan (Version): Geography in Education (16) Category: Pedagogy, teacher training and social care 2 Recommended year of study:2, Recommended semester: Summer
Faculty: Faculty of Education Study plan (Version): Geography in Education (17) Category: Pedagogy, teacher training and social care 2 Recommended year of study:2, Recommended semester: Summer
Faculty: Faculty of Education Study plan (Version): Studies in Mathematics (18) Category: Mathematics courses 2 Recommended year of study:2, Recommended semester: Summer
Faculty: Faculty of Education Study plan (Version): Physical Education in Education (18) Category: Physical education and sport 2 Recommended year of study:2, Recommended semester: Summer
Faculty: Faculty of Education Study plan (Version): Chemistry in Education (16) Category: Chemistry courses 2 Recommended year of study:2, Recommended semester: Summer
Faculty: Faculty of Education Study plan (Version): Information Technologies in Education (18) Category: Informatics courses 2 Recommended year of study:2, Recommended semester: Summer
Faculty: Faculty of Education Study plan (Version): Information Technologies in Education (18) Category: Informatics courses 2 Recommended year of study:2, Recommended semester: Summer
Faculty: Faculty of Education Study plan (Version): Information Technologies in Education (17) Category: Informatics courses 2 Recommended year of study:2, Recommended semester: Summer
Faculty: Faculty of Education Study plan (Version): History in Education (17) Category: History courses 2 Recommended year of study:2, Recommended semester: Summer
Faculty: Faculty of Education Study plan (Version): Chemistry in Education (18) Category: Chemistry courses 2 Recommended year of study:2, Recommended semester: Summer
Faculty: Faculty of Education Study plan (Version): English Language in Education (17) Category: Pedagogy, teacher training and social care 2 Recommended year of study:2, Recommended semester: Summer
Faculty: Faculty of Education Study plan (Version): Physics in Education (19) Category: Physics courses 2 Recommended year of study:2, Recommended semester: Summer
Faculty: Faculty of Education Study plan (Version): English Language in Education (18) Category: Pedagogy, teacher training and social care 2 Recommended year of study:2, Recommended semester: Summer
Faculty: Faculty of Education Study plan (Version): History in Education (18) Category: History courses 2 Recommended year of study:2, Recommended semester: Summer
Faculty: Faculty of Education Study plan (Version): Chemistry in Education (17) Category: Chemistry courses 2 Recommended year of study:2, Recommended semester: Summer
Faculty: Faculty of Education Study plan (Version): Physical Education in Education (17) Category: Physical education and sport 2 Recommended year of study:2, Recommended semester: Summer
Faculty: Faculty of Education Study plan (Version): Russian Language in Education (17) Category: Pedagogy, teacher training and social care 2 Recommended year of study:2, Recommended semester: Summer
Faculty: Faculty of Education Study plan (Version): Biology in Education (18) Category: Biology courses 2 Recommended year of study:2, Recommended semester: Summer
Faculty: Faculty of Education Study plan (Version): English Language in Education (19) Category: Pedagogy, teacher training and social care 2 Recommended year of study:2, Recommended semester: Summer
Faculty: Faculty of Education Study plan (Version): Biology in Education (16) Category: Biology courses 2 Recommended year of study:2, Recommended semester: Summer
Faculty: Faculty of Education Study plan (Version): Technology and Design in Education (17) Category: Pedagogy, teacher training and social care 2 Recommended year of study:2, Recommended semester: Summer
Faculty: Faculty of Education Study plan (Version): Studies in Mathematics (19) Category: Mathematics courses 2 Recommended year of study:2, Recommended semester: Summer
Faculty: Faculty of Education Study plan (Version): Chemistry in Education (19) Category: Chemistry courses 2 Recommended year of study:2, Recommended semester: Summer
Faculty: Faculty of Education Study plan (Version): Technology and Design in Education (18) Category: Pedagogy, teacher training and social care 2 Recommended year of study:2, Recommended semester: Summer
Faculty: Faculty of Education Study plan (Version): Russian Language in Education (19) Category: Pedagogy, teacher training and social care 2 Recommended year of study:2, Recommended semester: Summer
Faculty: Faculty of Education Study plan (Version): Technology and Design in Education (16) Category: Pedagogy, teacher training and social care 2 Recommended year of study:2, Recommended semester: Summer
Faculty: Faculty of Education Study plan (Version): Studies in Mathematics (17) Category: Mathematics courses 2 Recommended year of study:2, Recommended semester: Summer
Faculty: Faculty of Education Study plan (Version): Biology in Education (17) Category: Biology courses 2 Recommended year of study:2, Recommended semester: Summer
Faculty: Faculty of Education Study plan (Version): Physics in Education (17) Category: Physics courses 2 Recommended year of study:2, Recommended semester: Summer
Faculty: Faculty of Education Study plan (Version): Technology and Design in Education (19) Category: Pedagogy, teacher training and social care 2 Recommended year of study:2, Recommended semester: Summer
Faculty: Faculty of Education Study plan (Version): Russian Language in Education (18) Category: Pedagogy, teacher training and social care 2 Recommended year of study:2, Recommended semester: Summer
Faculty: Faculty of Education Study plan (Version): Physical Education in Education (16) Category: Physical education and sport 2 Recommended year of study:2, Recommended semester: Summer
Faculty: Faculty of Education Study plan (Version): Information Technologies in Education (19) Category: Informatics courses 2 Recommended year of study:2, Recommended semester: Summer
Faculty: Faculty of Education Study plan (Version): Information Technologies in Education (17) Category: Informatics courses 2 Recommended year of study:2, Recommended semester: Summer
Faculty: Faculty of Education Study plan (Version): Biology in Education (19) Category: Biology courses 2 Recommended year of study:2, Recommended semester: Summer
University of West Bohemia, date of update: 26.07.2024 23:53. Data created for academic year 2024/2025