Database System Decomposition

Course guarantor:

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.

No apriori knowledge of database systems is necessary.

Requirements:

The PDF report containing:

- task assignment (integrity constraint) with at least one M:N relationship that will lead to at least five tables. For attributes whose names do not make clear what they are for, provide example(s) of their values in parentheses,

- ERA model (can be hand-drawn),

- list of at least three useful views (more is better), with at least one view addressing the M:N relationship (i.e. combining data into a whole) and at least one containing attributes that are not part of the data in the physical tables (i.e. GROUP BY). Provide a brief description for each view (i.e. what its purpose is).

The report is NOT created using SQL.

The grade will be determined based on an oral presentation of the report, and knowledge of the decomposition methodology will be tested.

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: