Database System Decomposition

Garant předmětu:

Jaromír Kukal

Lecturer:

Jaromír Kukal, Dana Majerová

Tutor:

Jaromír Kukal, Dana Majerová

Supervisor:

Department of Software Engineering

Synopsis:

The lectures are oriented to basic terms, database objects, their properties and relationships together with the accent to logics of decomposition and applications of database operations.

Requirements:

No apriori knowledge of database systems is necessary.

Syllabus of lectures:

1 Sense and advantages of analysis and decomposition.

2 Table, normal forms of tables, entity.

3 Primary and unique key, index file and fast data acces.

4 Argumentation against decomposition and pragmatic approach.

5 Relations 1:n, 1:1, m:n, integrity constrains: DI, EI, RI.

6 Code book, join entity, hierarchy of entities.

7 Multiple and recurent relations.

8 Database system, ER and ERA models.

9 Database operations, Codd model and its current modification.

10 Role of expressions in database systems.

11 Role of undefined and defaoult values.

12 Roles of views and procesures.

13 Events and triggers.

Syllabus of tutorials:

Study Objective:

Knowledge:

Introduction to database thinking via database decomposition and operations over database objects. From basic terms to ERA model and Codd operations respecting the complexity of real applications.

Abilities:

Orientation in given subject and ability to solve real tasks.

Study materials:

Key references:

[1] Umanath N. S., Scamell R. W.: Data Modeling and Database Design, 2nd edition, Cengage Learning, 2014.

[2] Coronel C., Morris S.: Database Systems: Design, Implementation, & Management, 13th edition, Cengage, 2018.

Recommended references:

[3] Connolly T., Begg C.: Database Systems, Addison Wesley, 2005.

[4] Garcia-Molina H., Ullman J.: Database Systems, Prentice Hall, 2008.

Note:

Time-table for winter semester 2024/2025:

Time-table is not available yet

Time-table for summer semester 2024/2025:

Time-table is not available yet

The course is a part of the following study plans:

• Aplikovaná algebra a analýza (elective course)
• Aplikace informatiky v přírodních vědách (compulsory course in the program)
• Matematická informatika (elective course)