Database 1

Relations:

In order to register for course 818DTB1, the student must have registered for course 818DTB2 in a previous semester.

Course guarantor:

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 2024/2025:

	06:00–08:0008:00–10:0010:00–12:0012:00–14:0014:00–16:0016:00–18:0018:00–20:0020:00–22:0022:00–24:00
Mon
Tue
Wed	roomDC:PL1 Nový J. 08:00–09:50 (lecture parallel1) Decin roomDC:PL1 Majerová D. 08:00–09:50 (lecture parallel1) Decin
Thu
Fri

Time-table for summer semester 2024/2025:

Time-table is not available yet

The course is a part of the following study plans:

• Applications of Informatics in Natural Sciences (elective course)