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

Database 1

Login to KOS for course enrollment Display time-table
Code Completion Credits Range Language
818DTB1 KZ 2 2C Czech
Vztahy:
In order to register for course 818DTB1, the student must have registered for course 818DTB2 in a previous semester.
Garant předmětu:
Josef Nový
Lecturer:
Josef Nový
Tutor:
Josef Nový
Supervisor:
Department of Software Engineering
Synopsis:

The aim of the course „Database 1“ is to introduce students to the principles of normalization of relational databases and their design. The course is implemented only in the city of Děčín.

Requirements:
Syllabus of lectures:
Syllabus of tutorials:

Lecture/exercise syllabus:

1. Basic concepts (data, information, information system, etc.), bulk data processing vs. database approach. Database system.

2. Database technology: characteristics of data in databases, DBS users, functions of database management system.

3. Data models: network and hierarchical.

4. Data models: relational.

5. Data models: object-oriented and object-relational. Comparison with relational data model.

6. Conceptual models, M:N relation decomposition, ISA hierarchy.

7. Relational database design, database schema normalization, normal forms of tables.

8.-13. Practical examples of relational database design.

Study Objective:
Study materials:
Note:
Time-table for winter semester 2023/2024:
Time-table is not available yet
Time-table for summer semester 2023/2024:
Time-table is not available yet
The course is a part of the following study plans:
Data valid to 2024-07-14
Aktualizace výše uvedených informací naleznete na adrese https://bilakniha.cvut.cz/en/predmet7606806.html