Data Processing Theory

Lectures:

- Introduction into database technologies.
- Conceptual modeling. Entity, entity type, relation, integrity constraints, ER diagram, UML diagam
- Relational data model. Relation, relational scheme, relational database.
- Relational algebra. Basic operations.
- SQL language (with focus to SQL 92)
- SQL - DDL, DML, data types.
- SQL - příkaz SELECT.
- SQL - join operation, efficiency of a query processing.
- Transformation of an conceptual model to a relational data model.
- Functional dependencies.
- Normal forms and BCNF.
- Functional and dynamic analysis.


Exercises:

- Introduction into a ER modeling tool.
- Creation of ER models using the ER modeling tool.
- Introduction into a DBMS interfaces.
- SQL - DDL.
- SQL - DML.
- SQL - SELECT command.
- SQL processing efficiency
- Transformation of an conceptual model to a relational data model.
- Database design, BCNF.
- Functional and dynamic analysis.