Relational databases

Lecturer:

Pavel Loupal (gar.)

Tutor:

Pavel Loupal (gar.)

Supervisor:

Department of Mathematics

Synopsis:

Data processing, DBMS concepts and architecture, data models, E-R model, database models, network, hierarchical and relational model, relational algebra, formal query language, relational database design, functional dependencies, normalization, design algorithms; mapping E-R concepts to the database models, query language SQL,DDL,DML, integrity constraints; transaction, error recovery, parallel access, data security, client-server architecture, physical level data view.

Requirements:

Basic knowledge of the set theory and general algebra

Syllabus of lectures:

1. Basic principles of DBS, DBMS architecture.

2. Conceptual, database and physical level of view on data.

3. Conceptual data model. Basic constructs, integrity constraints.

4. Overview and comparison of database models - network, relational, object-relational and object.

5. Relational data model, relational algebra.

6. Normal forms. Normalization of database model.

7. Approaches for relational data model design.

8. SQL.

9. Transactions, failure recovery.

10. Physical data model.

Syllabus of tutorials:

Study Objective:

The relational data model. Meaning, construction and utilization. Theoretical approaches for employment of such model.

Skills: Construction of a relational model for given problem. Utilization of relational algebra and SQL for particular model.

Study materials:

Recommended references:

[3] Date, C. J. An Introduction to Database Systems. Addison-Wesley, 1995. ISBN 0-201-82458-2.

Media and tools: ER modelling tool

Note:

Time-table for winter semester 2011/2012:

Time-table is not available yet

Time-table for summer semester 2011/2012:

Time-table is not available yet

The course is a part of the following study plans: