|
Lecturer(s)
|
-
Buriánek Zbyněk, Mgr.
-
Holý Milan, Mgr. Ph.D.
-
Dolejš Tomáš, 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.
|