The lecture introduces the area of databases: database draft, entity-relationship model, relational algebra, structured query language (SQL), architecture of database systems, concurrency control and transactions concept.
 

Data management: Components of a database system and advantages of the database deployment; Organisation, data architecture, data organisation and techniques.

Entity-Relationship Model: Entities, associations, relations; Aggregation, generalisation; Transformation rules for entity and relation sets.

Relational model: Normal forms; Functional, transitive and multivalued dependencies; Extension of the relational model.

Relational algebra: Set and relation oriented operators, different join operators, completeness, predicate calculus.

Structured Query Language (SQL): Introduction to SQL, data definition and manipulation, views concept, authorization, integrity conditions.

Architecture of database systems: Layers architecture, translation, query optimization, tree and space organised memory structures.
 

Multiuser operating: Transactions, serialisability, pessimistc and optimistic methods, two phase locking protocol.
 

Work with a database system: Data protection and security, archive after the generation principle, error treatment, tuning and optimization.
 

Post-relational databases: Object relational and object oriented databases, databases for online analytical processing (OLAP), fuzzy databases

Key Words: Database Management System, Entity Relationship Model, Query Language, Transaction Management, Data Protection and Security