Course details

Database Systems

IDS Acad. year 2023/2024 Summer semester 5 credits

Fundamentals of database systems (DBS). Conceptual Modelling. The relational model. Relational database design from a conceptual model. Normalization-based design of a relational database. SQL language. Transaction processing. DBS architectures: client/server, multi-tier architectures, distributed DBS. Introduction to database administration: data security and integrity, introduction to physical database design, performance optimization, database recovery, concurrency control. Trends in database technology. The project consists in designing the structure of a relational database and programming SQL scripts to create the database, querying data in it, database triggers, and stored procedures.


Course coordinator

Language of instruction

Czech, English


Credit+Examination (written)

Time span

  • 39 hrs lectures
  • 13 hrs projects

Assessment points

  • 51 pts final exam (written part)
  • 15 pts mid-term test (written part)
  • 34 pts projects




Learning objectives

Mastering fundamentals of relational database theory and skill in using database technology at a level required for database design, development of database applications and database administration.

  • Student is able to develop conceptual models of an application domain for database applications.
  • He/she can develop database applications for relational databases, knows the standard database language for relational databases SQL, and has experience with some integrated development environment for database applications.  and have knowledge of relational database management system fundamentals.
  • He/she receives basic competencies for database administrator's work like user account creation, access rights assignment and performance tuning.
  • Student acquaints with fundamentals of some important functions of advanced database system like transactional processing, concurrency and recovery.
  • Student acquaints with basic English terminology in the subject.
  • The student will learn how to analyze a given problem in a small team and he/she will learn to design and implement a solution of the problem individually. He/she learns to present and defend both partial and final results of the project.

Why is the course taught

Since the 1960s, when data intensive applications and systems have been developed and used, typically information systems and their parts, database systems have been used to store data. Database technologies have evolved rapidly and are widely used today. It is, therefore, necessary for students to acquire competencies and skills in this field. This subject is focused on the basics of database technologies, namely relational databases that play a key role here.

Recommended prerequisites

Prerequisite knowledge and skills

The sets, relations and mappings. The elementary notions of the graph theory. Basics of hashing and tree-based search. Basic steps of software development. Rudiments of programming and data modelling.

Technical equipment


  • Oracle Database Server, Oracle SQL Developer, SQL Plus

Study literature

  • Lemahieu, W., Broucke, S., Baesens, B.: Principles of Database Management. Cambridge University Press. 2018, 780 p.
  • Zendulka, J., Bartík, V.: Databázové systémy. Přednášky v elektronické podobě.
  • Zendulka, J., Rudolfová, I.: Databázové systémy. IDS. Studijní opora. FIT VUT v Brně. 2006, 217 s.
  • Silberschatz, A., Korth H.F, Sudarshan, S.: Database System Concepts. Sixth Edition. McGraw-Hill. 2010, 1320 p.
  • On-line nápověda produktů Oracle, dokumentace dostupná na

Fundamental literature

  • Silberschatz, A., Korth H.F, Sudarshan, S.: Database System Concepts. Sixth Edition. McGraw-Hill. 2010, 1320 p.

Syllabus of lectures

  1. Fundamental concepts of database systems.
  2. Conceptual modelling.
  3. Fundamentals of the relational model. Transformation of a conceptual model to a relational database schema.
    Introduction the Oracle database, database tools. 
  4. Introduction to normal forms, the use of normalization in database design.
  5. The SQL - data definition.
  6. The SQL - SELECT statement (fundamentals).
  7. The SQL - SELECT statement (extension).
  8. The SQL - other statements for data manipulation. System catalogue.
  9. The SQL - views, missing information, embedded SQL, cursor, dynamic SQL. Query by example (QBE).
    Introduction to the PL/SQL language. 
  10. The client/server architecture. Database triggers and stored procedures. Data integrity, data security.
  11. Data organization at the internal level - indexing and hashing. Query processing and optimization.
    Query optimization, indexing and database transactions in Oracle.
  12. Transaction processing - properties and states of  a database transaction. Introduction to failure recovery and concurrency control.
  13. Current trends in database technology.

Syllabus - others, projects and individual work of students

  1. Presentation of a conceptual model (ERD or a class diagram) and a use case model for a given problem (continuation of the project started in the subject Introduction to software engineering).
  2. An SQL script that creates and populates database tables.
  3. An SQL script with queries over the database tables.
  4. An SQL script with statements for advanced database objects and project documentation.

Progress assessment

  • Data and use case models - 5 points
  • Building of the database in SQL - 5 points 
  • Querying in SQL - 5 points
  • Advanced database objects and documentation - 19 points
  • Midterm written exam - 15 points
  • Final written examination - 51 points
  • To be allowed to sit for written examination student is  to present and defend project oucomes in due dates, and to earn at least 24 points during the semester.
  • The minimum number of points for the final examination is 20.

Mid-term exam passing, realization and presentation/defence of projects in due dates.

In the case of a reported barrier of the mid-term exam and to present/defend a project, a student will be offered a substitute date of the exam or an oral exam, and she/he will be allowed to present/defend the project in a substitute date, respectively.

Exam prerequisites

To be allowed to sit for written examination student is present and defend project outcomes, and to earn at least 24 points during the semester.


Mon other 2024-05-06 N103 09:0010:00 Obhajoba projektu IDS: 2024-05-06 9:00-10:00
Mon other 2024-05-06 N103 10:0011:00 Obhajoba projektu IDS: 2024-05-06 10:00-11:00
Mon other 2024-04-29 N203 13:0013:50 Obhajoba projektu IDS: 2024-04-29 13:00-13:50
Mon other 2024-05-06 N103 13:0014:00 Obhajoba projektu IDS: 2024-05-06 13:00-14:00
Mon other 2024-04-29 N203 14:0015:00 Obhajoba projektu IDS: 2024-04-29 14:00-15:00
Tue other 2024-04-30 N203 08:0009:00 Obhajoba projektu IDS: 2024-04-30 08:00-09:00
Tue other 2024-04-30 N203 09:0009:50 Obhajoba projektu IDS: 2024-04-30 09:00-09:50
Tue exam 2024-04-02 D105 10:0011:00 Půlsemestální zkouška - 1. běh
Tue lecture 1., 6. of lectures D105 10:0012:50316 2BIB 3BIT xx 20 - 29 Bartík
Tue lecture 2., 3., 4., 5., 7., 8., 9., 10., 11., 12., 13. of lectures D105 10:0012:50316 2BIB 3BIT xx 20 - 29 Rychlý
Tue exam 2024-04-02 D105 11:0012:00 Půlsemestální zkouška - 2. běh
Tue other 2024-02-27 D105 12:0012:50 Hromadná konzultace - Konceptuální modelování - úterý 27.2.
Tue other 2024-03-12 D105 12:0012:50 Hromadná konzultace - Normalizace schématu DB - úterý 12.3.
Tue other 2024-03-19 D105 12:0012:50 Hromadná konzultace - Transformace konc. modelu na rel. DB - úterý 19.3
Tue other 2024-03-26 D105 12:0012:50 Hromadná konzultace - Dotazování v SQL - úterý 26.3.
Tue other 2024-04-30 N203 13:0014:00 Obhajoba projektu IDS: 2024-04-30 13:00-14:00
Tue other 2024-04-30 N203 14:0015:00 Obhajoba projektu IDS: 2024-04-30 14:00-15:00
Wed lecture 1., 3., 4., 5., 6., 8., 9., 10., 11., 12. of lectures E104 E105 E112 08:0010:50294 2BIA 3BIT xx 10 - 19 Bartík
Wed lecture 2., 7. of lectures E104 E105 E112 08:0010:50294 2BIA 3BIT xx 10 - 19 Rychlý
Wed exam 2024-06-05 D0206 D105 10:0011:50 3. termín
Wed other 2024-02-28 E112 10:0010:50 Hromadná konzultace - Konceptuální modelování - středa 28.2.
Wed other 2024-03-13 E112 10:0010:50 Hromadná konzultace - Normalizace schématu DB - středa 13.3
Wed other 2024-03-20 E112 10:0010:50 Hromadná konzultace - Transformace konc. modelu na rel. DB - středa 20.3
Wed other 2024-03-27 E112 10:0010:50 Hromadná konzultace - Dotazování v SQL - středa 27.3
Thu exam 2024-05-23 D0206 D0207 D105 E112 12:0013:50 2. termín
Fri other 2024-05-03 N103 08:3009:30 Obhajoba projektu IDS: 2024-05-03 8:30-9:30
Fri other 2024-05-03 N103 09:4010:40 Obhajoba projektu IDS: 2024-05-03 9:40-10:40
Fri exam 2024-05-10 A112 A113 D0206 D0207 D105 E104 E105 E112 G202 10:0011:50 1. termín
Fri other 2024-05-03 N103 12:4013:30 Obhajoba projektu IDS: 2024-05-03 12:40-13:30
Fri other 2024-05-03 N103 13:3014:20 Obhajoba projektu IDS: 2024-05-03 13:30-14:20

Course inclusion in study plans

  • Programme BIT, 2nd year of study, Compulsory
  • Programme BIT (in English), 2nd year of study, Compulsory
  • Programme IT-BC-3, field BIT, 2nd year of study, Compulsory
Back to top