Š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.
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.
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
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
Pokorný, J.: Databázové systémy a jejich použití v informačních systémech. Academia Praha, 1992