Database 1

The course is not on the list Without time-table

Code	Completion	Credits	Range	Language
818DTB1	KZ	2	2C	Czech

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

Garant předmětu:

Lecturer:

Tutor:

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:

Further information:

No time-table has been prepared for this course

The course is a part of the following study plans:

Applications of Informatics in Natural Sciences (elective course)