Reverse Database Engineering

Reverse Database Engineering can expedite your database design by far for tracking down the Foreign Key relationships, Primary Keys and all indexes, stored procedures, Triggers and Views right into your data modelling tool. When we use xCase as data modelling tool, it is also useful as Reverse Engineering Software

Here is the video to demonstrate Reverse Database Engineering:

Prevent data redundancy

Database that was not design properly can cause a duplicated data in the application. In this case when you enter data somewhere you need to save it in several other places in order for the system to work properly. Due to this problem, later, when you need to modify some data you will need to process all other tables where the same data is stored.

The above is a major flaw in the design and it breaks the basic rule that is needed to prevent data redundancy. In a normal design you enter the data in one place and use that data all over. Data stored only once guarantee consistency all over the application and this way one change of data could be reflected anywhere in the application. Redundant data will cause a lot of UN predicted issues. Database design using data modeling tools will prevent and will optimize the entire development while saving money to the client. In addition for future changes it will be easier to have a global view of the entire database and implement new changes quite rapidly.

Database Normalization Basics

In relational database design, the process of organizing data and prevent redundancy is called normalization. The idea is to enter the data only once and use the same data all over the system. In the process of storing data in efficient way, the idea is to eliminate redundancy. The design of tables in database will be in one of the five possible normal forms. Each normal form contains and enforces the rules of the previous form. The first 3 forms are the most popular ones.


Below is a snippet from the 100 tables model.

Each dotted line between one table to another represents a relation between each table. If you observe the Students table in brown color then the Sat1 is a child of that table. In a database design relations between tables are part of the actual design.

FIGURE 1:

We perform system analysis, software testing - quality assurance and data modeling. We provide custom made reports into your database such as: MS Sql Server, Oracle, Ms-Access and Visual FoxPro and others.

Software Requirements Specification

Without specs preparation and analysis of the requirements needed it is NOT feasible to assess the scope of work needed for a total re-write of an application if it is needed. The above will include the database design as shown in figure 1 and figure 2 and will be used for the entire new development process. At the end of the design the data modeling tool will create the entire data base with all relations captions fields names. When ever a change is occurred it will be implemented via our data modeling tool .

When you design a database while using a data modeling tool, you can also provide notes of the business rules and formulas as you discuss the specs with the client and enter all in the entity which represents either the table or view. Some additional info can be checked within this page as: database design and data modeling services and we cover more detail of the process.

You may also check our-software requirements specification process and we strive on getting the micro detail of each process.

Got questions about unleashing the full potential of your project?
We’ve got the answers!

Contact Us

Search