Database System Decomposition

Garant předmětu:

Lecturer:

Tutor:

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:

Further information:

No time-table has been prepared for this course

The course is a part of the following study plans:

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