SubjectsSubjects(version: 955)
Course, academic year 2023/2024
Database Systems Design - B445011
Title: Návrhy databázových systémů
Guaranteed by: Department of Mathematics, Informatics and Cybernetics (446)
Faculty: Faculty of Chemical Engineering
Actual: from 2021
Semester: summer
Points: summer s.:5
E-Credits: summer s.:5
Examination process: summer s.:
Hours per week, examination: summer s.:1/3, C+Ex [HT]
Capacity: unlimited / unlimited (unknown)
Min. number of students: unlimited
State of the course: taught
Language: Czech
Teaching methods: full-time
Teaching methods: full-time
Note: course can be enrolled in outside the study plan
enabled for web enrollment
Guarantor: Kukal Jaromír doc. Ing. Ph.D.
Interchangeability : N445052
Annotation -
The course focuses on the theory of relational database management systems, conceptual modelling and relational database schema normalization and gaining practical skills at a level required for database schema design including integrity constraints, for implementation of the design in a transactional relational database engine and for working with the database engine using the SQL query language and its procedural extension.
Last update: Fialová Jana (15.01.2018)
Aim of the course -

Students will be able to:

  • design database schemas based on relational data model and normal forms of tables,
  • create and manage database schemas using the SQL language in a modern client-server relational database system,
  • check the integrity of stored data using standard database means (keys, transactions),
  • work with the data using features of the procedural extension of the SQL language (stored procedures and functions, triggers).

Last update: Fialová Jana (15.01.2018)
Literature -

R:Ponniah P.,Database design and development: an essential guide for IT professionals,Wiley-Interscience,Hoboken,NJ,2003,0471218774

A:Ramakrishnan R. and Gehrke J.,Database management systems,McGraw-Hill,Boston,MA,2003,0072465638

A:Rob P. and Coronel C.,Database systems: design, implementation, and management,Thomson/Course Technology,Boston,MA,2007,1418836508

A:Chao L.,Database development and management,Auerbach Publ.,Boca Raton,FL,2006,0849333180

Last update: Fialová Jana (15.01.2018)
Learning resources -

Last update: Fialová Jana (15.01.2018)
Syllabus -

  1. Basic principles of DBS, DBMS architecture, functions of components.
  2. Conceptual, logical and physical level of view on data.
  3. Network, relational, object-relational and object oriented database models.
  4. Relational data model, entities, relationships, attributes, domains, schemas of relational databases.
  5. Normal forms of relations.
  6. Normalization of relational database model.
  7. Environment of modern client-server relational database system.
  8. Data types, schema creation, data definition using SQL statements.
  9. Data operations using SQL statements, views.
  10. Basic features and syntax of procedural extension of SQL language.
  11. Commands of procedural extension of SQL language and declaration of variables within the database system.
  12. Stored procedures and functions, triggers and sequences creation.
  13. Working with cursors in procedural extension of SQL language.
  14. Commands for definition and control of transactions.

Last update: Fialová Jana (15.01.2018)
Registration requirements -

Applications of Computer Science - N445001

Database Systems - N445003

Last update: Fialová Jana (15.01.2018)
Course completion requirements - Czech

zápočet - odevzdání protokolů ze samostatných úkolů

zkouška - ústní

Last update: Mareš Jan (14.02.2018)
Teaching methods
Activity Credits Hours
Obhajoba individuálního projektu 0.5 14
Účast na přednáškách 0.5 14
Práce na individuálním projektu 1 28
Příprava na zkoušku a její absolvování 1.5 42
Účast na seminářích 1.5 42
5 / 5 140 / 140