Department of Information Systems

Analysis of the current database model and design of the new model

Czech title:Analýza současného databázového modelu a návrhu nového modelu
Research leader:Bartík Vladimír
Team members:Volf Tomáš
Agency:Investiční aukce s.r.o.
We offer a project that involves analyzing the current database model and designing a new model that: removes design shortcomings, removes shortcomings against normal forms, removes redundant and unused entities and attributes, optimizes attribute data types, and integrates support for concurrently developed system functionalities. Following is the preparation of a one-time or incremental migration plan from the old to the new model, the data conversion tool, and the codebase system.


The research team processes the design deficiencies of the database model - places of unclear relation and lack of logical separation of data.

Formal design defects of the database model - cause data redundancy and increase the complexity of database queries.

Inappropriate data types - complicate data validation during processing.

The presence of redundant and unused data - complicates work with the database and increases the risk of human error.
Project description:
The expected timetable is as follows:

1. Analysis of the existing database model - 2 weeks

2. Removal of design deficiencies (eg business division and authentication logic) - 3 weeks

3. Normalization of the database (according to normal forms of relational database design) - 2 weeks

4. Removing redundancies and unused entities and attributes - 1 week

5. Optimization of data types - 1 week

6. Inclusion of data support of the developed functionalities - 2 weeks

7. Create a conversion tool from the old model to the new one - 3 weeks

8. Create migration plan - 2 weeks
9. Modifying the codebase system for the new model - 3 weeks


2017BARTÍK Vladimír and VOLF Tomáš. Zpráva z řešení projektu - Analýza současného databázového modelu a návrh nového modelu. Brno: Investiční aukce s.r.o., 2017.

Your IPv4 address:
Switch to https