Database-Design

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.