|
|
|
||
Last update: RNDr. Filip Zavoral, Ph.D. (03.04.2001)
|
|
||
Last update: RNDr. Filip Zavoral, Ph.D. (29.09.2003)
Pokorný J., Halaška I.: Databázové systémy. Vybrané kapitoly a cvičení. UK Praha, KAROLINUM, 1998.
Pokorný J., Halaška I.: Databázové systémy. FEL ČVUT Praha, 1998.
Pokorný J.: Základy implementace souborů a databází. UK Praha, KAROLINUM, 1997.
Pokorný J.: Konstrukce databázových systémů. FEL ČVUT Praha, 1999.
Pokorny J., Dotazovaci jazyky, Karolinum, Praha, 2002. |
|
||
Last update: T_KSI (23.05.2002)
Basic concepts. Motivation and history of database technology. External, conceptual, logical and internal database schema.
Conceptual modelling - ER model, ER diagram, other constructs of conceptual models. Relational data model. Database schema, admissible databases. Transformation of ER diagram to relational database schema.
Database design - criteria of good design of a relation, especially the 3rd normal form. Methods and algorithms of database schema design, properties of schemas (dependency covering and decomposition losslessness).
Procedural and nonprocedural database languages ( relational algebra and calculus). Commercial query languages - SQL.
Dynamic file organization - B-trees, extendible hashing.
Architectures of database systems. Client - server architecture.
Trends in database technology - object-oriented and object-relational technology. |