Logo ČVUT
CZECH TECHNICAL UNIVERSITY IN PRAGUE
STUDY PLANS
2024/2025

Relational Databases

The course is not on the list Without time-table
Code Completion Credits Range Language
01REDA ZK 3 3+0 Czech
Garant předmětu:
Lecturer:
Tutor:
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:
Further information:
No time-table has been prepared for this course
The course is a part of the following study plans:
Data valid to 2024-05-18
Aktualizace výše uvedených informací naleznete na adrese https://bilakniha.cvut.cz/en/predmet11363905.html