Database 1

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:

• Applications of Informatics in Natural Sciences (elective course)