Course: Database systems

« Back
Course title Database systems
Course code AUPKS/A1DBS
Organizational form of instruction Lecture + Tutorial
Level of course Bachelor
Year of study not specified
Semester Winter
Number of ECTS credits 5
Language of instruction Czech, English
Status of course Compulsory
Form of instruction Face-to-face
Work placements This is not an internship
Recommended optional programme components None
  • Tureček Tomáš, Ing.
  • Šilhavý Petr, Ing. Ph.D.
  • Prokopová Zdenka, doc. Ing. CSc.
Course content
- Introduction to DBS - basic terms, structure, table, indexes, primary key, data types... - Conceptual models - data flow diagrams. - Relational model. - Database design - normal forms. - Relational algebra. - SQL - basic commands. - SQL - data selection. - SQL - aggregations and functions. - SQL - subqueries, views. - Data security. - Transactions. - Database system architectures. - Physical implementation of DBS. - Indexing.

Learning activities and teaching methods
Monologic (Exposition, lecture, briefing), Dialogic (Discussion, conversation, brainstorming), Methods for working with texts (Textbook, book), Demonstration, Exercises on PC, Practice exercises
Learning outcomes
The subject is aimed at mastering principles of relational Data Base System theory and obtaining practical skill using database technologies at the level needed for database design, creation of database applications and administration of data base systems. Component part of subject is familiarization of students with SQL query language.
The student has knowledge about design of relational database structures. The student is able to implement simple database system. The student knows how to use basic commands of SQL query language. The student is well informed in methods of database transactions. The student is qualified for selection, sorting and execution of information from relational databases.
Basic knowledge from mathematics, informatics and programming.

Assessment methods and criteria
Grade (Using a grade system), Written examination, Analysis of the student's performance, Conversation, Systematic observation of the student

Attendance: Compulsory at seminars (80%). Short tests: 4 tests, a maximum of 3 points can be awarded in each test. The minimum requirement for credit test is 6 points (together from all tests). Main test: A maximum of 20 points can be awarded in written test. More then 50% of points is the minimum requirement; if the student fails to pass the test, he/she must resit for the test (1 opportunity for correction). Examination: successful main test and completion and defence of an individual project. The result of a subject examination is expressed on a six-point scale: A "výborně" (i.e. "excellent"), B "velmi dobře" (i.e. "very good"), C "dobře" (i.e. "good"), D "uspokojivě" (i.e. "satisfactory"), E "dostatečně" (i.e. "sufficient"), F "nedostatečně" (i.e. "fail").
Recommended literature
  • HERNANDEZ M.J. Návrh databází. Grada, 2006.
  • Keogh, James Edward. Datové struktury bez předchozích znalostí. Vyd. 1. Praha : Computer Press, 2006. ISBN 80-251-0689-6.
  • Prokopová, Zdenka. Databázové systémy MySQL + PHP. Vyd. 1. Zlín : Univerzita Tomáše Bati ve Zlíně. Fakulta aplikované informatiky, 2006. ISBN 80-7318-486-9.
  • Riordan, Rebecca M. Vytváříme relační databázové aplikace. Brno : Computer Press, 2000. ISBN 80-7226-360-9.
  • Roman, Steven. Microsoft Access : návrh a programování databází. 1. vyd. Brno : Computer Press, 1999. ISBN 8072261347.
  • SILBERSCHATZ, A., KORTH, H.F., SUDARSHAN, S. Database System Concepts. McGraw-Hill, 2005. ISBN 0-07-295886-3.

Study plans that include the course
Faculty Study plan (Version) Branch of study Category Recommended year of study Recommended semester
Faculty of Applied Informatics Software Engineering (16) Special and interdisciplinary fields 1 Winter