Skip to main content
Skip header

Introduction to Database Theory

Language of instruction čeština
Code 456-0901
Abbreviation UTDS
Course title Introduction to Database Theory
Coordinating department Department of Computer Science
Course coordinator doc. RNDr. Jana Šarmanová, CSc.

Summary

An overview of database management. An architecture for a database system. The internal
level, indexing, hashing, pointer chains. The logical level, entity-relationship model, ERD.
Relational model. Domains, relations, relational integrity rules, relational databases.
Relational algebra, calculus. SQL, QBE. Further normalization, functional dependence, first,
second and third normal forms, Boyce-Codd normal form, decompositions.
The network model, data definition, data manipulation.

Literature

Šarmanová, J.: Teorie zpracování dat. Skriptum VŠB-TU Ostrava, 2007.
Šarmanová, J.: Databázové a informační systémy. Skriptum VŠB-TU Ostrava, 2007.

Advised literature

Date, C. J.: An Inproduction to Database Systems. 5th Edition, Reading, 1990
Pokorný, J.: Databázové systémy a jejich použití v informačních systémech. Academia Praha, 1992